eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IMPORT_UTILITIES_PKG dependencies on AP_BATCHES

Line 663: it is read off the AP_BATCHES table.

659: This function returns a batch_id and batch_type given a batch_name.
660: If the batch already exists the batch_type returned is 'OLD BATCH',
661: else the batch_type returned is 'NEW BATCH'. If this is a NEW
662: BATCH the batch_id is obtained from the appropriate sequence, else
663: it is read off the AP_BATCHES table.
664: ========================================================================*/
665: FUNCTION get_batch_id (
666: p_batch_name IN VARCHAR2,
667: P_batch_id OUT NOCOPY NUMBER,

Line 698: FROM ap_batches_all

694: SELECT 'OLD BATCH',
695: batch_id
696: INTO p_batch_type,
697: l_batch_id
698: FROM ap_batches_all
699: WHERE batch_name = P_batch_name;
700:
701: EXCEPTION
702: WHEN NO_DATA_FOUND THEN

Line 717: SELECT ap_batches_s.nextval

713: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
714: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
715: END IF;
716:
717: SELECT ap_batches_s.nextval
718: INTO l_batch_id
719: FROM sys.dual;
720:
721: END IF;

Line 765: SELECT ap_batches_s2.nextval

761: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
762: Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
763: END IF;
764:
765: SELECT ap_batches_s2.nextval
766: INTO l_batch_num
767: FROM sys.dual;
768:
769: p_batch_name := p_source || ':' || to_char(l_batch_num);

Line 3469: Private Procedure: Insert new AP_BATCHES lines

3465:
3466: END Update_temp_invoice_status;
3467:
3468: /*======================================================================
3469: Private Procedure: Insert new AP_BATCHES lines
3470:
3471: Insert New Batch line if the batch name is new
3472: ======================================================================*/
3473:

Line 3474: FUNCTION Insert_ap_batches(

3470:
3471: Insert New Batch line if the batch name is new
3472: ======================================================================*/
3473:
3474: FUNCTION Insert_ap_batches(
3475: p_batch_id IN NUMBER,
3476: p_batch_name IN VARCHAR2,
3477: p_invoice_currency_code IN VARCHAR2,
3478: p_payment_currency_code IN VARCHAR2,

Line 3490: current_calling_sequence := 'Insert_ap_batches<-'||p_calling_sequence;

3486: debug_info VARCHAR2(500);
3487: BEGIN
3488: -- Update the calling sequence
3489:
3490: current_calling_sequence := 'Insert_ap_batches<-'||p_calling_sequence;
3491:
3492: ---------------------------------------------
3493: -- Insert ap_batches
3494: ---------------------------------------------

Line 3493: -- Insert ap_batches

3489:
3490: current_calling_sequence := 'Insert_ap_batches<-'||p_calling_sequence;
3491:
3492: ---------------------------------------------
3493: -- Insert ap_batches
3494: ---------------------------------------------
3495: debug_info := 'Insert ap_batches';
3496: -- bug 5441261. Insert should be into AP_BATCHES_ALL
3497: INSERT INTO ap_batches_all(

Line 3495: debug_info := 'Insert ap_batches';

3491:
3492: ---------------------------------------------
3493: -- Insert ap_batches
3494: ---------------------------------------------
3495: debug_info := 'Insert ap_batches';
3496: -- bug 5441261. Insert should be into AP_BATCHES_ALL
3497: INSERT INTO ap_batches_all(
3498: batch_id,
3499: batch_name,

Line 3496: -- bug 5441261. Insert should be into AP_BATCHES_ALL

3492: ---------------------------------------------
3493: -- Insert ap_batches
3494: ---------------------------------------------
3495: debug_info := 'Insert ap_batches';
3496: -- bug 5441261. Insert should be into AP_BATCHES_ALL
3497: INSERT INTO ap_batches_all(
3498: batch_id,
3499: batch_name,
3500: batch_date,

Line 3497: INSERT INTO ap_batches_all(

3493: -- Insert ap_batches
3494: ---------------------------------------------
3495: debug_info := 'Insert ap_batches';
3496: -- bug 5441261. Insert should be into AP_BATCHES_ALL
3497: INSERT INTO ap_batches_all(
3498: batch_id,
3499: batch_name,
3500: batch_date,
3501: last_update_date,

Line 3543: END Insert_ap_batches;

3539: END IF;
3540:
3541: RETURN (FALSE);
3542:
3543: END Insert_ap_batches;
3544:
3545: /*======================================================================
3546: Function: Update_Ap_Batches
3547: This function updates the value of control invoice count and

Line 3546: Function: Update_Ap_Batches

3542:
3543: END Insert_ap_batches;
3544:
3545: /*======================================================================
3546: Function: Update_Ap_Batches
3547: This function updates the value of control invoice count and
3548: control invoice total in ap_batches
3549: ======================================================================*/
3550:

Line 3548: control invoice total in ap_batches

3544:
3545: /*======================================================================
3546: Function: Update_Ap_Batches
3547: This function updates the value of control invoice count and
3548: control invoice total in ap_batches
3549: ======================================================================*/
3550:
3551: FUNCTION Update_Ap_Batches(
3552: p_batch_id IN NUMBER,

Line 3551: FUNCTION Update_Ap_Batches(

3547: This function updates the value of control invoice count and
3548: control invoice total in ap_batches
3549: ======================================================================*/
3550:
3551: FUNCTION Update_Ap_Batches(
3552: p_batch_id IN NUMBER,
3553: p_batch_name IN VARCHAR2,
3554: p_actual_invoice_count IN NUMBER,
3555: p_actual_invoice_total IN NUMBER,

Line 3567: current_calling_sequence :='Update_Ap_Batches<-'||p_calling_sequence;

3563: BEGIN
3564:
3565: -- Update the calling sequence
3566:
3567: current_calling_sequence :='Update_Ap_Batches<-'||p_calling_sequence;
3568:
3569: -- Update ap_batches
3570:
3571: debug_info :='Update ap_batches';

Line 3569: -- Update ap_batches

3565: -- Update the calling sequence
3566:
3567: current_calling_sequence :='Update_Ap_Batches<-'||p_calling_sequence;
3568:
3569: -- Update ap_batches
3570:
3571: debug_info :='Update ap_batches';
3572:
3573: UPDATE ap_batches

Line 3571: debug_info :='Update ap_batches';

3567: current_calling_sequence :='Update_Ap_Batches<-'||p_calling_sequence;
3568:
3569: -- Update ap_batches
3570:
3571: debug_info :='Update ap_batches';
3572:
3573: UPDATE ap_batches
3574: SET control_invoice_count =
3575: NVL(control_invoice_count,0)+

Line 3573: UPDATE ap_batches

3569: -- Update ap_batches
3570:
3571: debug_info :='Update ap_batches';
3572:
3573: UPDATE ap_batches
3574: SET control_invoice_count =
3575: NVL(control_invoice_count,0)+
3576: p_actual_invoice_count,
3577: control_invoice_total =

Line 3604: END Update_ap_Batches;

3600: END IF;
3601:
3602: RETURN(FALSE);
3603:
3604: END Update_ap_Batches;
3605:
3606: /*=========================================================================*/
3607: /* */
3608: /* Function Insert_Ap_Invoices_lines */