DBA Data[Home] [Help]

APPS.ARP_RATE_ADJUSTMENTS_PKG dependencies on STANDARD

Line 13: arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );

9: p_radj_id OUT NOCOPY ar_rate_adjustments.rate_adjustment_id%TYPE ) IS
10: l_radj_id ar_rate_adjustments.rate_adjustment_id%TYPE;
11: BEGIN
12: IF PG_DEBUG in ('Y', 'C') THEN
13: arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );
14: END IF;
15: --
16: SELECT AR_RATE_ADJUSTMENTS_s.nextval
17: INTO l_radj_id

Line 90: NVL( arp_standard.profile.request_id,

86: p_radj_rec.attribute12,
87: p_radj_rec.attribute13,
88: p_radj_rec.attribute14,
89: p_radj_rec.attribute15,
90: NVL( arp_standard.profile.request_id,
91: p_radj_rec.request_id ),
92: NVL( arp_standard.profile.program_application_id,
93: p_radj_rec.program_application_id ),
94: NVL( arp_standard.profile.program_id,

Line 92: NVL( arp_standard.profile.program_application_id,

88: p_radj_rec.attribute14,
89: p_radj_rec.attribute15,
90: NVL( arp_standard.profile.request_id,
91: p_radj_rec.request_id ),
92: NVL( arp_standard.profile.program_application_id,
93: p_radj_rec.program_application_id ),
94: NVL( arp_standard.profile.program_id,
95: p_radj_rec.program_id ),
96: DECODE( arp_standard.profile.program_id,

Line 94: NVL( arp_standard.profile.program_id,

90: NVL( arp_standard.profile.request_id,
91: p_radj_rec.request_id ),
92: NVL( arp_standard.profile.program_application_id,
93: p_radj_rec.program_application_id ),
94: NVL( arp_standard.profile.program_id,
95: p_radj_rec.program_id ),
96: DECODE( arp_standard.profile.program_id,
97: NULL, NULL,
98: SYSDATE

Line 96: DECODE( arp_standard.profile.program_id,

92: NVL( arp_standard.profile.program_application_id,
93: p_radj_rec.program_application_id ),
94: NVL( arp_standard.profile.program_id,
95: p_radj_rec.program_id ),
96: DECODE( arp_standard.profile.program_id,
97: NULL, NULL,
98: SYSDATE
99: ),
100: arp_standard.profile.user_id,

Line 100: arp_standard.profile.user_id,

96: DECODE( arp_standard.profile.program_id,
97: NULL, NULL,
98: SYSDATE
99: ),
100: arp_standard.profile.user_id,
101: SYSDATE,
102: arp_standard.profile.user_id,
103: SYSDATE,
104: NVL( arp_standard.profile.last_update_login,

Line 102: arp_standard.profile.user_id,

98: SYSDATE
99: ),
100: arp_standard.profile.user_id,
101: SYSDATE,
102: arp_standard.profile.user_id,
103: SYSDATE,
104: NVL( arp_standard.profile.last_update_login,
105: p_radj_rec.last_update_login )
106: ,arp_standard.sysparm.org_id /* SSA changes anuj */

Line 104: NVL( arp_standard.profile.last_update_login,

100: arp_standard.profile.user_id,
101: SYSDATE,
102: arp_standard.profile.user_id,
103: SYSDATE,
104: NVL( arp_standard.profile.last_update_login,
105: p_radj_rec.last_update_login )
106: ,arp_standard.sysparm.org_id /* SSA changes anuj */
107: );
108: --

Line 106: ,arp_standard.sysparm.org_id /* SSA changes anuj */

102: arp_standard.profile.user_id,
103: SYSDATE,
104: NVL( arp_standard.profile.last_update_login,
105: p_radj_rec.last_update_login )
106: ,arp_standard.sysparm.org_id /* SSA changes anuj */
107: );
108: --
109: /*---------------------------------+
110: | Calling central MRC library |

Line 124: arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );

120:
121: p_radj_id := l_radj_id;
122: --
123: IF PG_DEBUG in ('Y', 'C') THEN
124: arp_standard.debug( 'arp_rate_adjustments_pkg.insert_p()+' );
125: END IF;
126: EXCEPTION
127: WHEN OTHERS THEN
128: IF PG_DEBUG in ('Y', 'C') THEN

Line 129: arp_standard.debug( 'EXCEPTION: arp_rate_adjustments_pkg.insert_p' );

125: END IF;
126: EXCEPTION
127: WHEN OTHERS THEN
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_standard.debug( 'EXCEPTION: arp_rate_adjustments_pkg.insert_p' );
130: END IF;
131: RAISE;
132: END insert_p;
133: --