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_R11_PREPAY_PKG dependencies on AP_INVOICE_PREPAYS

Line 412: * -- Step 9ip : case i and p: Invoice: prepayment : Update AP_INVOICE_PREPAYS

408:
409:
410:
411: /*--------------------------------------------------------------------------
412: * -- Step 9ip : case i and p: Invoice: prepayment : Update AP_INVOICE_PREPAYS
413: * Call appp_insert_invoice_prepay:
414: * 1. Update ap_invoice_prepays if there's a invoice_prepay line exit.
415: * 2. Delete record if unapply the prepayment.
416: * 3. Insert new line if there's no such record exist

Line 414: * 1. Update ap_invoice_prepays if there's a invoice_prepay line exit.

410:
411: /*--------------------------------------------------------------------------
412: * -- Step 9ip : case i and p: Invoice: prepayment : Update AP_INVOICE_PREPAYS
413: * Call appp_insert_invoice_prepay:
414: * 1. Update ap_invoice_prepays if there's a invoice_prepay line exit.
415: * 2. Delete record if unapply the prepayment.
416: * 3. Insert new line if there's no such record exist
417: ---------------------------------------------------------------------------*/
418: ap_r11_prepay_pkg.appp_insert_invoice_prepay(

Line 1860: This precedure use for maintaining AP_INVOICE_PREPAYS

1856:
1857:
1858:
1859: /*===========================================================================
1860: This precedure use for maintaining AP_INVOICE_PREPAYS
1861: 1. Update ap_invoice_prepays if there's a invoice_prepay line exit.
1862: 2. Delete record if unapply the prepayment.
1863: 3. Insert new line if there's no such record exist
1864: ===========================================================================*/

Line 1861: 1. Update ap_invoice_prepays if there's a invoice_prepay line exit.

1857:
1858:
1859: /*===========================================================================
1860: This precedure use for maintaining AP_INVOICE_PREPAYS
1861: 1. Update ap_invoice_prepays if there's a invoice_prepay line exit.
1862: 2. Delete record if unapply the prepayment.
1863: 3. Insert new line if there's no such record exist
1864: ===========================================================================*/
1865: PROCEDURE appp_insert_invoice_prepay(

Line 1886: -- Update ap_invoice_prepays if there's a invoice_prepay line exit

1882: --
1883: current_calling_sequence := 'appp_insert_invoice_prepay<-'||X_calling_sequence;
1884:
1885: ------------------------------------------------------------------
1886: -- Update ap_invoice_prepays if there's a invoice_prepay line exit
1887: ------------------------------------------------------------------
1888: debug_info := 'Update ap_invoice_prepays';
1889: UPDATE ap_invoice_prepays
1890: SET prepayment_amount_applied = prepayment_amount_applied +

Line 1888: debug_info := 'Update ap_invoice_prepays';

1884:
1885: ------------------------------------------------------------------
1886: -- Update ap_invoice_prepays if there's a invoice_prepay line exit
1887: ------------------------------------------------------------------
1888: debug_info := 'Update ap_invoice_prepays';
1889: UPDATE ap_invoice_prepays
1890: SET prepayment_amount_applied = prepayment_amount_applied +
1891: ap_utilities_pkg.ap_round_precision(
1892: X_amount_apply, X_min_unit, X_precision),

Line 1889: UPDATE ap_invoice_prepays

1885: ------------------------------------------------------------------
1886: -- Update ap_invoice_prepays if there's a invoice_prepay line exit
1887: ------------------------------------------------------------------
1888: debug_info := 'Update ap_invoice_prepays';
1889: UPDATE ap_invoice_prepays
1890: SET prepayment_amount_applied = prepayment_amount_applied +
1891: ap_utilities_pkg.ap_round_precision(
1892: X_amount_apply, X_min_unit, X_precision),
1893: last_update_date = SYSDATE,

Line 1903: debug_info := 'Delete record from ap_invoice_prepays';

1899:
1900: ------------------------------------------------------------------
1901: -- Delete record if unapply the prepayment
1902: ------------------------------------------------------------------
1903: debug_info := 'Delete record from ap_invoice_prepays';
1904: if (X_amount_apply < 0)
1905: then /* Same as X_amount_positive = 'N' */
1906: DELETE FROM ap_invoice_prepays
1907: WHERE prepay_id = X_prepay_id

Line 1906: DELETE FROM ap_invoice_prepays

1902: ------------------------------------------------------------------
1903: debug_info := 'Delete record from ap_invoice_prepays';
1904: if (X_amount_apply < 0)
1905: then /* Same as X_amount_positive = 'N' */
1906: DELETE FROM ap_invoice_prepays
1907: WHERE prepay_id = X_prepay_id
1908: AND invoice_id = X_invoice_id
1909: AND prepayment_amount_applied = 0;
1910:

Line 1915: debug_info := 'Insert record from ap_invoice_prepays';

1911: else
1912: ------------------------------------------------------------------
1913: -- Insert new line if there's no record exist
1914: ------------------------------------------------------------------
1915: debug_info := 'Insert record from ap_invoice_prepays';
1916:
1917: INSERT INTO ap_invoice_prepays(
1918: prepay_id,
1919: invoice_id,

Line 1917: INSERT INTO ap_invoice_prepays(

1913: -- Insert new line if there's no record exist
1914: ------------------------------------------------------------------
1915: debug_info := 'Insert record from ap_invoice_prepays';
1916:
1917: INSERT INTO ap_invoice_prepays(
1918: prepay_id,
1919: invoice_id,
1920: prepayment_amount_applied,
1921: last_update_date,

Line 1940: FROM ap_invoice_prepays

1936: X_org_id /* Bug 3700128. MOAC Project */
1937: FROM SYS.DUAL
1938: WHERE NOT EXISTS (
1939: SELECT 'Already updated existing record'
1940: FROM ap_invoice_prepays
1941: WHERE prepay_id = X_prepay_id
1942: AND invoice_id = X_invoice_id);
1943: end if;
1944: