DBA Data[Home] [Help]

APPS.ARP_MAINTAIN_PS2 dependencies on ARP_TRX_GLOBAL

Line 50: system_info arp_trx_global.system_info_rec_type :=

46:
47: -- This record holds general information used by autoaccounting and
48: -- credit memo module. Passed as argument to most functions/procs.
49: --
50: system_info arp_trx_global.system_info_rec_type :=
51: arp_trx_global.system_info;
52:
53: --
54: -- This record holds profile information used by autoaccounting and

Line 51: arp_trx_global.system_info;

47: -- This record holds general information used by autoaccounting and
48: -- credit memo module. Passed as argument to most functions/procs.
49: --
50: system_info arp_trx_global.system_info_rec_type :=
51: arp_trx_global.system_info;
52:
53: --
54: -- This record holds profile information used by autoaccounting and
55: -- credit memo module. Passed as argument to most functions/procs.

Line 57: profile_info arp_trx_global.profile_rec_type :=

53: --
54: -- This record holds profile information used by autoaccounting and
55: -- credit memo module. Passed as argument to most functions/procs.
56: --
57: profile_info arp_trx_global.profile_rec_type :=
58: arp_trx_global.profile_info;
59:
60: /*
61: bug 4891386-4923502 Modified the datatype of every column having

Line 58: arp_trx_global.profile_info;

54: -- This record holds profile information used by autoaccounting and
55: -- credit memo module. Passed as argument to most functions/procs.
56: --
57: profile_info arp_trx_global.profile_rec_type :=
58: arp_trx_global.profile_info;
59:
60: /*
61: bug 4891386-4923502 Modified the datatype of every column having
62: Binary Integer to Number(15) for all record types select_ips_rec_type,

Line 449: p_system_info IN arp_trx_global.system_info_rec_type,

445: -- HISTORY:
446: --
447: ----------------------------------------------------------------------------
448: PROCEDURE build_ips_sql(
449: p_system_info IN arp_trx_global.system_info_rec_type,
450: p_profile_info IN arp_trx_global.profile_rec_type,
451: p_select_c IN OUT NOCOPY INTEGER,
452: p_insert_ps_c IN OUT NOCOPY INTEGER ) IS
453:

Line 450: p_profile_info IN arp_trx_global.profile_rec_type,

446: --
447: ----------------------------------------------------------------------------
448: PROCEDURE build_ips_sql(
449: p_system_info IN arp_trx_global.system_info_rec_type,
450: p_profile_info IN arp_trx_global.profile_rec_type,
451: p_select_c IN OUT NOCOPY INTEGER,
452: p_insert_ps_c IN OUT NOCOPY INTEGER ) IS
453:
454: l_insert_ps_sql VARCHAR2(5000);

Line 916: p_system_info IN arp_trx_global.system_info_rec_type,

912:
913: ------------------------------------------------------------------------
914:
915: PROCEDURE process_ips_data(
916: p_system_info IN arp_trx_global.system_info_rec_type,
917: p_profile_info IN arp_trx_global.profile_rec_type,
918: p_insert_ps_c IN INTEGER,
919: p_select_rec IN select_ips_rec_type,
920: p_number_of_due_dates IN NUMBER,

Line 917: p_profile_info IN arp_trx_global.profile_rec_type,

913: ------------------------------------------------------------------------
914:
915: PROCEDURE process_ips_data(
916: p_system_info IN arp_trx_global.system_info_rec_type,
917: p_profile_info IN arp_trx_global.profile_rec_type,
918: p_insert_ps_c IN INTEGER,
919: p_select_rec IN select_ips_rec_type,
920: p_number_of_due_dates IN NUMBER,
921: p_percent_t IN number_table_type,

Line 1231: p_system_info IN arp_trx_global.system_info_rec_type,

1227:
1228:
1229: ----------------------------------------------------------------------------
1230: PROCEDURE insert_inv_ps_private(
1231: p_system_info IN arp_trx_global.system_info_rec_type,
1232: p_profile_info IN arp_trx_global.profile_rec_type,
1233: p_customer_trx_id IN BINARY_INTEGER,
1234: p_reversed_cash_receipt_id IN BINARY_INTEGER ) IS
1235:

Line 1232: p_profile_info IN arp_trx_global.profile_rec_type,

1228:
1229: ----------------------------------------------------------------------------
1230: PROCEDURE insert_inv_ps_private(
1231: p_system_info IN arp_trx_global.system_info_rec_type,
1232: p_profile_info IN arp_trx_global.profile_rec_type,
1233: p_customer_trx_id IN BINARY_INTEGER,
1234: p_reversed_cash_receipt_id IN BINARY_INTEGER ) IS
1235:
1236: l_ignore INTEGER;

Line 1472: p_system_info IN arp_trx_global.system_info_rec_type,

1468: -- HISTORY:
1469: --
1470: ----------------------------------------------------------------------------
1471: PROCEDURE build_ira_sql(
1472: p_system_info IN arp_trx_global.system_info_rec_type,
1473: p_profile_info IN arp_trx_global.profile_rec_type,
1474: p_select_c IN OUT NOCOPY INTEGER,
1475: p_insert_ps_c IN OUT NOCOPY INTEGER,
1476: p_insert_ra_c IN OUT NOCOPY INTEGER,

Line 1473: p_profile_info IN arp_trx_global.profile_rec_type,

1469: --
1470: ----------------------------------------------------------------------------
1471: PROCEDURE build_ira_sql(
1472: p_system_info IN arp_trx_global.system_info_rec_type,
1473: p_profile_info IN arp_trx_global.profile_rec_type,
1474: p_select_c IN OUT NOCOPY INTEGER,
1475: p_insert_ps_c IN OUT NOCOPY INTEGER,
1476: p_insert_ra_c IN OUT NOCOPY INTEGER,
1477: p_update_ps_c IN OUT NOCOPY INTEGER ) IS

Line 2456: p_system_info IN arp_trx_global.system_info_rec_type,

2452:
2453: ------------------------------------------------------------------------
2454:
2455: PROCEDURE process_ira_data(
2456: p_system_info IN arp_trx_global.system_info_rec_type,
2457: p_profile_info IN arp_trx_global.profile_rec_type,
2458: p_insert_ps_c IN INTEGER,
2459: p_insert_ra_c IN INTEGER,
2460: p_update_ps_c IN INTEGER,

Line 2457: p_profile_info IN arp_trx_global.profile_rec_type,

2453: ------------------------------------------------------------------------
2454:
2455: PROCEDURE process_ira_data(
2456: p_system_info IN arp_trx_global.system_info_rec_type,
2457: p_profile_info IN arp_trx_global.profile_rec_type,
2458: p_insert_ps_c IN INTEGER,
2459: p_insert_ra_c IN INTEGER,
2460: p_update_ps_c IN INTEGER,
2461: p_select_rec IN select_ira_rec_type,

Line 3136: p_system_info IN arp_trx_global.system_info_rec_type,

3132:
3133:
3134: ----------------------------------------------------------------------------
3135: PROCEDURE insert_cm_ps_private(
3136: p_system_info IN arp_trx_global.system_info_rec_type,
3137: p_profile_info IN arp_trx_global.profile_rec_type,
3138: p_customer_trx_id IN BINARY_INTEGER ) IS
3139:
3140: l_ignore INTEGER;

Line 3137: p_profile_info IN arp_trx_global.profile_rec_type,

3133:
3134: ----------------------------------------------------------------------------
3135: PROCEDURE insert_cm_ps_private(
3136: p_system_info IN arp_trx_global.system_info_rec_type,
3137: p_profile_info IN arp_trx_global.profile_rec_type,
3138: p_customer_trx_id IN BINARY_INTEGER ) IS
3139:
3140: l_ignore INTEGER;
3141:

Line 3522: p_system_info IN arp_trx_global.system_info_rec_type,

3518: -- 01-JUN-01 1483656 - Updated select, insert, and update to allocate
3519: -- tax and freight to deposits.
3520: ----------------------------------------------------------------------------
3521: PROCEDURE build_ups_sql(
3522: p_system_info IN arp_trx_global.system_info_rec_type,
3523: p_profile_info IN arp_trx_global.profile_rec_type,
3524: p_select_c IN OUT NOCOPY INTEGER,
3525: p_insert_adj_c IN OUT NOCOPY INTEGER,
3526: p_update_ps_c IN OUT NOCOPY INTEGER ) IS

Line 3523: p_profile_info IN arp_trx_global.profile_rec_type,

3519: -- tax and freight to deposits.
3520: ----------------------------------------------------------------------------
3521: PROCEDURE build_ups_sql(
3522: p_system_info IN arp_trx_global.system_info_rec_type,
3523: p_profile_info IN arp_trx_global.profile_rec_type,
3524: p_select_c IN OUT NOCOPY INTEGER,
3525: p_insert_adj_c IN OUT NOCOPY INTEGER,
3526: p_update_ps_c IN OUT NOCOPY INTEGER ) IS
3527:

Line 4075: p_system_info IN arp_trx_global.system_info_rec_type,

4071: ------------------------------------------------------------------------
4072: -- 1483656 - added 5 new parameters to this proceedure
4073:
4074: PROCEDURE process_ups_data(
4075: p_system_info IN arp_trx_global.system_info_rec_type,
4076: p_profile_info IN arp_trx_global.profile_rec_type,
4077: p_insert_adj_c IN INTEGER,
4078: p_update_ps_c IN INTEGER,
4079: p_select_rec IN select_ups_rec_type,

Line 4076: p_profile_info IN arp_trx_global.profile_rec_type,

4072: -- 1483656 - added 5 new parameters to this proceedure
4073:
4074: PROCEDURE process_ups_data(
4075: p_system_info IN arp_trx_global.system_info_rec_type,
4076: p_profile_info IN arp_trx_global.profile_rec_type,
4077: p_insert_adj_c IN INTEGER,
4078: p_update_ps_c IN INTEGER,
4079: p_select_rec IN select_ups_rec_type,
4080: p_number_records IN NUMBER,

Line 4660: p_system_info IN arp_trx_global.system_info_rec_type,

4656:
4657:
4658: ----------------------------------------------------------------------------
4659: PROCEDURE insert_child_adj_private(
4660: p_system_info IN arp_trx_global.system_info_rec_type,
4661: p_profile_info IN arp_trx_global.profile_rec_type,
4662: p_customer_trx_id IN BINARY_INTEGER,
4663: p_adj_date IN DATE,
4664: p_gl_date IN DATE) IS

Line 4661: p_profile_info IN arp_trx_global.profile_rec_type,

4657:
4658: ----------------------------------------------------------------------------
4659: PROCEDURE insert_child_adj_private(
4660: p_system_info IN arp_trx_global.system_info_rec_type,
4661: p_profile_info IN arp_trx_global.profile_rec_type,
4662: p_customer_trx_id IN BINARY_INTEGER,
4663: p_adj_date IN DATE,
4664: p_gl_date IN DATE) IS
4665:

Line 5033: x_system_info arp_trx_global.system_info_rec_type;

5029: PROCEDURE insert_child_adj_private(p_customer_trx_id IN BINARY_INTEGER,
5030: p_adj_date IN DATE DEFAULT NULL,
5031: p_gl_date IN DATE DEFAULT NULL )
5032: IS
5033: x_system_info arp_trx_global.system_info_rec_type;
5034: x_profile_info arp_trx_global.profile_rec_type;
5035: BEGIN
5036:
5037: insert_child_adj_private(x_system_info, x_profile_info,

Line 5034: x_profile_info arp_trx_global.profile_rec_type;

5030: p_adj_date IN DATE DEFAULT NULL,
5031: p_gl_date IN DATE DEFAULT NULL )
5032: IS
5033: x_system_info arp_trx_global.system_info_rec_type;
5034: x_profile_info arp_trx_global.profile_rec_type;
5035: BEGIN
5036:
5037: insert_child_adj_private(x_system_info, x_profile_info,
5038: p_customer_trx_id, p_adj_date, p_gl_date);

Line 5069: p_system_info IN arp_trx_global.system_info_rec_type,

5065: -- HISTORY:
5066: --
5067: ----------------------------------------------------------------------------
5068: PROCEDURE build_iad_sql(
5069: p_system_info IN arp_trx_global.system_info_rec_type,
5070: p_profile_info IN arp_trx_global.profile_rec_type,
5071: p_select_c IN OUT NOCOPY INTEGER,
5072: p_insert_adj_c IN OUT NOCOPY INTEGER,
5073: p_update_ps_c IN OUT NOCOPY INTEGER ) IS

Line 5070: p_profile_info IN arp_trx_global.profile_rec_type,

5066: --
5067: ----------------------------------------------------------------------------
5068: PROCEDURE build_iad_sql(
5069: p_system_info IN arp_trx_global.system_info_rec_type,
5070: p_profile_info IN arp_trx_global.profile_rec_type,
5071: p_select_c IN OUT NOCOPY INTEGER,
5072: p_insert_adj_c IN OUT NOCOPY INTEGER,
5073: p_update_ps_c IN OUT NOCOPY INTEGER ) IS
5074:

Line 5667: p_system_info IN arp_trx_global.system_info_rec_type,

5663:
5664: ------------------------------------------------------------------------
5665:
5666: PROCEDURE process_iad_data(
5667: p_system_info IN arp_trx_global.system_info_rec_type,
5668: p_profile_info IN arp_trx_global.profile_rec_type,
5669: p_insert_adj_c IN INTEGER,
5670: p_update_ps_c IN INTEGER,
5671: p_select_rec IN select_iad_rec_type,

Line 5668: p_profile_info IN arp_trx_global.profile_rec_type,

5664: ------------------------------------------------------------------------
5665:
5666: PROCEDURE process_iad_data(
5667: p_system_info IN arp_trx_global.system_info_rec_type,
5668: p_profile_info IN arp_trx_global.profile_rec_type,
5669: p_insert_adj_c IN INTEGER,
5670: p_update_ps_c IN INTEGER,
5671: p_select_rec IN select_iad_rec_type,
5672: p_number_records IN NUMBER,

Line 6484: p_system_info IN arp_trx_global.system_info_rec_type,

6480:
6481:
6482: ----------------------------------------------------------------------------
6483: PROCEDURE insert_cm_child_adj_private(
6484: p_system_info IN arp_trx_global.system_info_rec_type,
6485: p_profile_info IN arp_trx_global.profile_rec_type,
6486: p_customer_trx_id IN BINARY_INTEGER ) IS
6487:
6488: l_ignore INTEGER;

Line 6485: p_profile_info IN arp_trx_global.profile_rec_type,

6481:
6482: ----------------------------------------------------------------------------
6483: PROCEDURE insert_cm_child_adj_private(
6484: p_system_info IN arp_trx_global.system_info_rec_type,
6485: p_profile_info IN arp_trx_global.profile_rec_type,
6486: p_customer_trx_id IN BINARY_INTEGER ) IS
6487:
6488: l_ignore INTEGER;
6489: