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 924: p_system_info IN arp_trx_global.system_info_rec_type,

920:
921: ------------------------------------------------------------------------
922:
923: PROCEDURE process_ips_data(
924: p_system_info IN arp_trx_global.system_info_rec_type,
925: p_profile_info IN arp_trx_global.profile_rec_type,
926: p_insert_ps_c IN INTEGER,
927: p_select_rec IN select_ips_rec_type,
928: p_number_of_due_dates IN NUMBER,

Line 925: p_profile_info IN arp_trx_global.profile_rec_type,

921: ------------------------------------------------------------------------
922:
923: PROCEDURE process_ips_data(
924: p_system_info IN arp_trx_global.system_info_rec_type,
925: p_profile_info IN arp_trx_global.profile_rec_type,
926: p_insert_ps_c IN INTEGER,
927: p_select_rec IN select_ips_rec_type,
928: p_number_of_due_dates IN NUMBER,
929: p_percent_t IN number_table_type,

Line 1239: p_system_info IN arp_trx_global.system_info_rec_type,

1235:
1236:
1237: ----------------------------------------------------------------------------
1238: PROCEDURE insert_inv_ps_private(
1239: p_system_info IN arp_trx_global.system_info_rec_type,
1240: p_profile_info IN arp_trx_global.profile_rec_type,
1241: p_customer_trx_id IN BINARY_INTEGER,
1242: p_reversed_cash_receipt_id IN BINARY_INTEGER ) IS
1243:

Line 1240: p_profile_info IN arp_trx_global.profile_rec_type,

1236:
1237: ----------------------------------------------------------------------------
1238: PROCEDURE insert_inv_ps_private(
1239: p_system_info IN arp_trx_global.system_info_rec_type,
1240: p_profile_info IN arp_trx_global.profile_rec_type,
1241: p_customer_trx_id IN BINARY_INTEGER,
1242: p_reversed_cash_receipt_id IN BINARY_INTEGER ) IS
1243:
1244: l_ignore INTEGER;

Line 1480: p_system_info IN arp_trx_global.system_info_rec_type,

1476: -- HISTORY:
1477: --
1478: ----------------------------------------------------------------------------
1479: PROCEDURE build_ira_sql(
1480: p_system_info IN arp_trx_global.system_info_rec_type,
1481: p_profile_info IN arp_trx_global.profile_rec_type,
1482: p_select_c IN OUT NOCOPY INTEGER,
1483: p_insert_ps_c IN OUT NOCOPY INTEGER,
1484: p_insert_ra_c IN OUT NOCOPY INTEGER,

Line 1481: p_profile_info IN arp_trx_global.profile_rec_type,

1477: --
1478: ----------------------------------------------------------------------------
1479: PROCEDURE build_ira_sql(
1480: p_system_info IN arp_trx_global.system_info_rec_type,
1481: p_profile_info IN arp_trx_global.profile_rec_type,
1482: p_select_c IN OUT NOCOPY INTEGER,
1483: p_insert_ps_c IN OUT NOCOPY INTEGER,
1484: p_insert_ra_c IN OUT NOCOPY INTEGER,
1485: p_update_ps_c IN OUT NOCOPY INTEGER ) IS

Line 2464: p_system_info IN arp_trx_global.system_info_rec_type,

2460:
2461: ------------------------------------------------------------------------
2462:
2463: PROCEDURE process_ira_data(
2464: p_system_info IN arp_trx_global.system_info_rec_type,
2465: p_profile_info IN arp_trx_global.profile_rec_type,
2466: p_insert_ps_c IN INTEGER,
2467: p_insert_ra_c IN INTEGER,
2468: p_update_ps_c IN INTEGER,

Line 2465: p_profile_info IN arp_trx_global.profile_rec_type,

2461: ------------------------------------------------------------------------
2462:
2463: PROCEDURE process_ira_data(
2464: p_system_info IN arp_trx_global.system_info_rec_type,
2465: p_profile_info IN arp_trx_global.profile_rec_type,
2466: p_insert_ps_c IN INTEGER,
2467: p_insert_ra_c IN INTEGER,
2468: p_update_ps_c IN INTEGER,
2469: p_select_rec IN select_ira_rec_type,

Line 3144: p_system_info IN arp_trx_global.system_info_rec_type,

3140:
3141:
3142: ----------------------------------------------------------------------------
3143: PROCEDURE insert_cm_ps_private(
3144: p_system_info IN arp_trx_global.system_info_rec_type,
3145: p_profile_info IN arp_trx_global.profile_rec_type,
3146: p_customer_trx_id IN BINARY_INTEGER ) IS
3147:
3148: l_ignore INTEGER;

Line 3145: p_profile_info IN arp_trx_global.profile_rec_type,

3141:
3142: ----------------------------------------------------------------------------
3143: PROCEDURE insert_cm_ps_private(
3144: p_system_info IN arp_trx_global.system_info_rec_type,
3145: p_profile_info IN arp_trx_global.profile_rec_type,
3146: p_customer_trx_id IN BINARY_INTEGER ) IS
3147:
3148: l_ignore INTEGER;
3149:

Line 3530: p_system_info IN arp_trx_global.system_info_rec_type,

3526: -- 01-JUN-01 1483656 - Updated select, insert, and update to allocate
3527: -- tax and freight to deposits.
3528: ----------------------------------------------------------------------------
3529: PROCEDURE build_ups_sql(
3530: p_system_info IN arp_trx_global.system_info_rec_type,
3531: p_profile_info IN arp_trx_global.profile_rec_type,
3532: p_select_c IN OUT NOCOPY INTEGER,
3533: p_insert_adj_c IN OUT NOCOPY INTEGER,
3534: p_update_ps_c IN OUT NOCOPY INTEGER ) IS

Line 3531: p_profile_info IN arp_trx_global.profile_rec_type,

3527: -- tax and freight to deposits.
3528: ----------------------------------------------------------------------------
3529: PROCEDURE build_ups_sql(
3530: p_system_info IN arp_trx_global.system_info_rec_type,
3531: p_profile_info IN arp_trx_global.profile_rec_type,
3532: p_select_c IN OUT NOCOPY INTEGER,
3533: p_insert_adj_c IN OUT NOCOPY INTEGER,
3534: p_update_ps_c IN OUT NOCOPY INTEGER ) IS
3535:

Line 4084: p_system_info IN arp_trx_global.system_info_rec_type,

4080: ------------------------------------------------------------------------
4081: -- 1483656 - added 5 new parameters to this proceedure
4082:
4083: PROCEDURE process_ups_data(
4084: p_system_info IN arp_trx_global.system_info_rec_type,
4085: p_profile_info IN arp_trx_global.profile_rec_type,
4086: p_insert_adj_c IN INTEGER,
4087: p_update_ps_c IN INTEGER,
4088: p_select_rec IN select_ups_rec_type,

Line 4085: p_profile_info IN arp_trx_global.profile_rec_type,

4081: -- 1483656 - added 5 new parameters to this proceedure
4082:
4083: PROCEDURE process_ups_data(
4084: p_system_info IN arp_trx_global.system_info_rec_type,
4085: p_profile_info IN arp_trx_global.profile_rec_type,
4086: p_insert_adj_c IN INTEGER,
4087: p_update_ps_c IN INTEGER,
4088: p_select_rec IN select_ups_rec_type,
4089: p_number_records IN NUMBER,

Line 4669: p_system_info IN arp_trx_global.system_info_rec_type,

4665:
4666:
4667: ----------------------------------------------------------------------------
4668: PROCEDURE insert_child_adj_private(
4669: p_system_info IN arp_trx_global.system_info_rec_type,
4670: p_profile_info IN arp_trx_global.profile_rec_type,
4671: p_customer_trx_id IN BINARY_INTEGER,
4672: p_adj_date IN DATE,
4673: p_gl_date IN DATE) IS

Line 4670: p_profile_info IN arp_trx_global.profile_rec_type,

4666:
4667: ----------------------------------------------------------------------------
4668: PROCEDURE insert_child_adj_private(
4669: p_system_info IN arp_trx_global.system_info_rec_type,
4670: p_profile_info IN arp_trx_global.profile_rec_type,
4671: p_customer_trx_id IN BINARY_INTEGER,
4672: p_adj_date IN DATE,
4673: p_gl_date IN DATE) IS
4674:

Line 5042: x_system_info arp_trx_global.system_info_rec_type;

5038: PROCEDURE insert_child_adj_private(p_customer_trx_id IN BINARY_INTEGER,
5039: p_adj_date IN DATE DEFAULT NULL,
5040: p_gl_date IN DATE DEFAULT NULL )
5041: IS
5042: x_system_info arp_trx_global.system_info_rec_type;
5043: x_profile_info arp_trx_global.profile_rec_type;
5044: BEGIN
5045:
5046: insert_child_adj_private(x_system_info, x_profile_info,

Line 5043: x_profile_info arp_trx_global.profile_rec_type;

5039: p_adj_date IN DATE DEFAULT NULL,
5040: p_gl_date IN DATE DEFAULT NULL )
5041: IS
5042: x_system_info arp_trx_global.system_info_rec_type;
5043: x_profile_info arp_trx_global.profile_rec_type;
5044: BEGIN
5045:
5046: insert_child_adj_private(x_system_info, x_profile_info,
5047: p_customer_trx_id, p_adj_date, p_gl_date);

Line 5078: p_system_info IN arp_trx_global.system_info_rec_type,

5074: -- HISTORY:
5075: --
5076: ----------------------------------------------------------------------------
5077: PROCEDURE build_iad_sql(
5078: p_system_info IN arp_trx_global.system_info_rec_type,
5079: p_profile_info IN arp_trx_global.profile_rec_type,
5080: p_select_c IN OUT NOCOPY INTEGER,
5081: p_insert_adj_c IN OUT NOCOPY INTEGER,
5082: p_update_ps_c IN OUT NOCOPY INTEGER ) IS

Line 5079: p_profile_info IN arp_trx_global.profile_rec_type,

5075: --
5076: ----------------------------------------------------------------------------
5077: PROCEDURE build_iad_sql(
5078: p_system_info IN arp_trx_global.system_info_rec_type,
5079: p_profile_info IN arp_trx_global.profile_rec_type,
5080: p_select_c IN OUT NOCOPY INTEGER,
5081: p_insert_adj_c IN OUT NOCOPY INTEGER,
5082: p_update_ps_c IN OUT NOCOPY INTEGER ) IS
5083:

Line 5676: p_system_info IN arp_trx_global.system_info_rec_type,

5672:
5673: ------------------------------------------------------------------------
5674:
5675: PROCEDURE process_iad_data(
5676: p_system_info IN arp_trx_global.system_info_rec_type,
5677: p_profile_info IN arp_trx_global.profile_rec_type,
5678: p_insert_adj_c IN INTEGER,
5679: p_update_ps_c IN INTEGER,
5680: p_select_rec IN select_iad_rec_type,

Line 5677: p_profile_info IN arp_trx_global.profile_rec_type,

5673: ------------------------------------------------------------------------
5674:
5675: PROCEDURE process_iad_data(
5676: p_system_info IN arp_trx_global.system_info_rec_type,
5677: p_profile_info IN arp_trx_global.profile_rec_type,
5678: p_insert_adj_c IN INTEGER,
5679: p_update_ps_c IN INTEGER,
5680: p_select_rec IN select_iad_rec_type,
5681: p_number_records IN NUMBER,

Line 6493: p_system_info IN arp_trx_global.system_info_rec_type,

6489:
6490:
6491: ----------------------------------------------------------------------------
6492: PROCEDURE insert_cm_child_adj_private(
6493: p_system_info IN arp_trx_global.system_info_rec_type,
6494: p_profile_info IN arp_trx_global.profile_rec_type,
6495: p_customer_trx_id IN BINARY_INTEGER ) IS
6496:
6497: l_ignore INTEGER;

Line 6494: p_profile_info IN arp_trx_global.profile_rec_type,

6490:
6491: ----------------------------------------------------------------------------
6492: PROCEDURE insert_cm_child_adj_private(
6493: p_system_info IN arp_trx_global.system_info_rec_type,
6494: p_profile_info IN arp_trx_global.profile_rec_type,
6495: p_customer_trx_id IN BINARY_INTEGER ) IS
6496:
6497: l_ignore INTEGER;
6498: