43: billing_profile_id oks_billing_profiles_b.ID%TYPE,
44: invoicing_rule oks_billing_profiles_b.invoice_object1_id1%TYPE,
45: accounting_rule oks_billing_profiles_b.account_object1_id1%TYPE,
46: transfer_date DATE,
47: credit_option oks_batch_rules.credit_option%TYPE,
48: termination_reason_code oks_batch_rules.termination_reason_code%TYPE,
49: retain_contract_number_flag oks_batch_rules.retain_contract_number_flag%TYPE,
50: contract_modifier oks_batch_rules.contract_modifier%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
44: invoicing_rule oks_billing_profiles_b.invoice_object1_id1%TYPE,
45: accounting_rule oks_billing_profiles_b.account_object1_id1%TYPE,
46: transfer_date DATE,
47: credit_option oks_batch_rules.credit_option%TYPE,
48: termination_reason_code oks_batch_rules.termination_reason_code%TYPE,
49: retain_contract_number_flag oks_batch_rules.retain_contract_number_flag%TYPE,
50: contract_modifier oks_batch_rules.contract_modifier%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
45: accounting_rule oks_billing_profiles_b.account_object1_id1%TYPE,
46: transfer_date DATE,
47: credit_option oks_batch_rules.credit_option%TYPE,
48: termination_reason_code oks_batch_rules.termination_reason_code%TYPE,
49: retain_contract_number_flag oks_batch_rules.retain_contract_number_flag%TYPE,
50: contract_modifier oks_batch_rules.contract_modifier%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
46: transfer_date DATE,
47: credit_option oks_batch_rules.credit_option%TYPE,
48: termination_reason_code oks_batch_rules.termination_reason_code%TYPE,
49: retain_contract_number_flag oks_batch_rules.retain_contract_number_flag%TYPE,
50: contract_modifier oks_batch_rules.contract_modifier%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
47: credit_option oks_batch_rules.credit_option%TYPE,
48: termination_reason_code oks_batch_rules.termination_reason_code%TYPE,
49: retain_contract_number_flag oks_batch_rules.retain_contract_number_flag%TYPE,
50: contract_modifier oks_batch_rules.contract_modifier%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
48: termination_reason_code oks_batch_rules.termination_reason_code%TYPE,
49: retain_contract_number_flag oks_batch_rules.retain_contract_number_flag%TYPE,
50: contract_modifier oks_batch_rules.contract_modifier%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
49: retain_contract_number_flag oks_batch_rules.retain_contract_number_flag%TYPE,
50: contract_modifier oks_batch_rules.contract_modifier%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
50: contract_modifier oks_batch_rules.contract_modifier%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
51: contract_status oks_batch_rules.contract_status%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
59: ship_address_id oks_batch_rules.ship_address_id%TYPE,
52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
59: ship_address_id oks_batch_rules.ship_address_id%TYPE,
60: bill_contact_id oks_batch_rules.bill_contact_id%TYPE,
53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
59: ship_address_id oks_batch_rules.ship_address_id%TYPE,
60: bill_contact_id oks_batch_rules.bill_contact_id%TYPE,
61: -- ship_contact_id oks_batch_rules.ship_contact_id%TYPE,
54: bill_lines_flag oks_batch_rules.bill_lines_flag%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
59: ship_address_id oks_batch_rules.ship_address_id%TYPE,
60: bill_contact_id oks_batch_rules.bill_contact_id%TYPE,
61: -- ship_contact_id oks_batch_rules.ship_contact_id%TYPE,
62: new_customer_id NUMBER, --oks_batch_rules.new_account_id%TYPE,
55: transfer_option oks_batch_rules.transfer_option_code%TYPE,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
59: ship_address_id oks_batch_rules.ship_address_id%TYPE,
60: bill_contact_id oks_batch_rules.bill_contact_id%TYPE,
61: -- ship_contact_id oks_batch_rules.ship_contact_id%TYPE,
62: new_customer_id NUMBER, --oks_batch_rules.new_account_id%TYPE,
63: new_party_id NUMBER,
56: bill_account_id oks_batch_rules.bill_account_id%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
59: ship_address_id oks_batch_rules.ship_address_id%TYPE,
60: bill_contact_id oks_batch_rules.bill_contact_id%TYPE,
61: -- ship_contact_id oks_batch_rules.ship_contact_id%TYPE,
62: new_customer_id NUMBER, --oks_batch_rules.new_account_id%TYPE,
63: new_party_id NUMBER,
64: party_name hz_parties.party_name%TYPE,
57: ship_account_id oks_batch_rules.ship_account_id%TYPE,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
59: ship_address_id oks_batch_rules.ship_address_id%TYPE,
60: bill_contact_id oks_batch_rules.bill_contact_id%TYPE,
61: -- ship_contact_id oks_batch_rules.ship_contact_id%TYPE,
62: new_customer_id NUMBER, --oks_batch_rules.new_account_id%TYPE,
63: new_party_id NUMBER,
64: party_name hz_parties.party_name%TYPE,
65: Batch_id NUMBER
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,
59: ship_address_id oks_batch_rules.ship_address_id%TYPE,
60: bill_contact_id oks_batch_rules.bill_contact_id%TYPE,
61: -- ship_contact_id oks_batch_rules.ship_contact_id%TYPE,
62: new_customer_id NUMBER, --oks_batch_rules.new_account_id%TYPE,
63: new_party_id NUMBER,
64: party_name hz_parties.party_name%TYPE,
65: Batch_id NUMBER
66: );
67:
68:
69: TYPE batch_rules_trm_type IS RECORD
70: (
71: credit_option oks_batch_rules.credit_option%TYPE,
72: termination_reason_code oks_batch_rules.termination_reason_code%TYPE
73: );
74: TYPE jtf_note_rec_type IS RECORD (
75: jtf_note_id NUMBER,
68:
69: TYPE batch_rules_trm_type IS RECORD
70: (
71: credit_option oks_batch_rules.credit_option%TYPE,
72: termination_reason_code oks_batch_rules.termination_reason_code%TYPE
73: );
74: TYPE jtf_note_rec_type IS RECORD (
75: jtf_note_id NUMBER,
76: source_object_code VARCHAR2 (240),