DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV dependencies on PO_DATES_S

Line 3205: x_val_open_ok := PO_DATES_S.val_open_period(x_cascaded_table(n).transaction_date,x_sob_id,'PO',

3201: SELECT set_of_books_id
3202: INTO x_sob_id
3203: FROM financials_system_parameters;
3204:
3205: x_val_open_ok := PO_DATES_S.val_open_period(x_cascaded_table(n).transaction_date,x_sob_id,'PO',
3206: x_cascaded_table(n).to_organization_id) AND
3207: PO_DATES_S.val_open_period(x_cascaded_table(n).transaction_date,x_sob_id,'SQLGL',
3208: x_cascaded_table(n).to_organization_id);
3209: EXCEPTION

Line 3207: PO_DATES_S.val_open_period(x_cascaded_table(n).transaction_date,x_sob_id,'SQLGL',

3203: FROM financials_system_parameters;
3204:
3205: x_val_open_ok := PO_DATES_S.val_open_period(x_cascaded_table(n).transaction_date,x_sob_id,'PO',
3206: x_cascaded_table(n).to_organization_id) AND
3207: PO_DATES_S.val_open_period(x_cascaded_table(n).transaction_date,x_sob_id,'SQLGL',
3208: x_cascaded_table(n).to_organization_id);
3209: EXCEPTION
3210: WHEN OTHERS THEN
3211: x_val_open_ok := FALSE;

Line 3232: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,

3228: END IF;
3229: END;
3230:
3231: BEGIN
3232: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,
3233: x_sob_id,
3234: 'SQLGL',
3235: x_cascaded_table(n).to_organization_id
3236: );

Line 3248: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,

3244: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
3245: END IF;
3246:
3247: BEGIN
3248: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,
3249: x_sob_id,
3250: 'INV',
3251: x_cascaded_table(n).to_organization_id
3252: );

Line 3264: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,

3260: rcv_error_pkg.log_interface_error('TRANSACTION_DATE');
3261: END IF;
3262:
3263: BEGIN
3264: x_val_open_ok := po_dates_s.val_open_period(x_cascaded_table(n).transaction_date,
3265: x_sob_id,
3266: 'PO',
3267: x_cascaded_table(n).to_organization_id
3268: );