DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_BATCH_RULES

Line 47: credit_option oks_batch_rules.credit_option%TYPE,

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,

Line 48: termination_reason_code oks_batch_rules.termination_reason_code%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,

Line 49: retain_contract_number_flag oks_batch_rules.retain_contract_number_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,

Line 50: contract_modifier oks_batch_rules.contract_modifier%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,

Line 51: contract_status oks_batch_rules.contract_status%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,

Line 52: transfer_notes_flag oks_batch_rules.transfer_notes_flag%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,

Line 53: transfer_attachments_flag oks_batch_rules.transfer_attachments_flag%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,

Line 54: bill_lines_flag oks_batch_rules.bill_lines_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,
58: bill_address_id oks_batch_rules.bill_address_id%TYPE,

Line 55: transfer_option oks_batch_rules.transfer_option_code%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,

Line 56: bill_account_id oks_batch_rules.bill_account_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,

Line 57: ship_account_id oks_batch_rules.ship_account_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,

Line 58: bill_address_id oks_batch_rules.bill_address_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,

Line 59: ship_address_id oks_batch_rules.ship_address_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,

Line 60: bill_contact_id oks_batch_rules.bill_contact_id%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,
64: party_name hz_parties.party_name%TYPE,

Line 61: -- ship_contact_id oks_batch_rules.ship_contact_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,
65: Batch_id NUMBER

Line 62: new_customer_id NUMBER, --oks_batch_rules.new_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
66: );

Line 71: credit_option oks_batch_rules.credit_option%TYPE,

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,

Line 72: termination_reason_code oks_batch_rules.termination_reason_code%TYPE

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),