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.JAI_PO_PROC_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 3337: rec_dist PO_DISTRIBUTIONS_ALL%ROWTYPE;

3333: REM +================================================================================================+
3334: */
3335: PROCEDURE process_dist(prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE) IS
3336:
3337: rec_dist PO_DISTRIBUTIONS_ALL%ROWTYPE;
3338:
3339: /*v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
3340: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;

Line 3339: /*v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;

3335: PROCEDURE process_dist(prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE) IS
3336:
3337: rec_dist PO_DISTRIBUTIONS_ALL%ROWTYPE;
3338:
3339: /*v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
3340: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
3342: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;

Line 3340: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;

3336:
3337: rec_dist PO_DISTRIBUTIONS_ALL%ROWTYPE;
3338:
3339: /*v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
3340: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
3342: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
3344: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;

Line 3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;

3337: rec_dist PO_DISTRIBUTIONS_ALL%ROWTYPE;
3338:
3339: /*v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
3340: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
3342: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
3344: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
3345: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;

Line 3342: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;

3338:
3339: /*v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
3340: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
3342: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
3344: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
3345: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
3346:

Line 3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;

3339: /*v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
3340: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
3342: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
3344: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
3345: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
3346:
3347: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;

Line 3344: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;

3340: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
3342: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
3344: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
3345: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
3346:
3347: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
3348:

Line 3345: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;

3341: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
3342: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
3344: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
3345: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
3346:
3347: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
3348:
3349: v_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 3347: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;

3343: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
3344: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
3345: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
3346:
3347: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
3348:
3349: v_type_lookup_code po_headers_all.type_lookup_code%TYPE;
3350: v_Quot_Class_Code po_headers_all.Quotation_Class_Code%TYPE;
3351: v_Ship_Loc_Id po_headers_all.Ship_To_Location_Id%TYPE;

Line 3365: FROM PO_DISTRIBUTIONS_ALL

3361: v_tax_modified_flag JAI_PO_LINE_LOCATIONS.tax_modified_flag%TYPE;
3362: */
3363: CURSOR c_dist IS
3364: SELECT *
3365: FROM PO_DISTRIBUTIONS_ALL
3366: WHERE PO_HEADER_ID = prec_po_location.po_header_id
3367: AND PO_LINE_ID = prec_po_location.po_line_id
3368: AND LINE_LOCATION_ID = prec_po_location.line_location_id;
3369:

Line 7658: pr_dist PO_DISTRIBUTIONS_ALL%ROWTYPE

7654:
7655: /*--Added below procedures/functions for bug16288154 start*/
7656: --Move the logic from process_dist to below for trigger use only
7657: PROCEDURE process_distribution_line(
7658: pr_dist PO_DISTRIBUTIONS_ALL%ROWTYPE
7659: ,pv_return_code OUT NOCOPY VARCHAR2
7660: ,pv_return_message OUT NOCOPY VARCHAR2
7661: )IS
7662: CURSOR get_po_hdr(c_po_header_id number) IS

Line 7685: v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;

7681: SELECT count(line_location_id)
7682: FROM JAI_PO_LINE_LOCATIONS
7683: WHERE line_location_id=c_line_location_id;
7684:
7685: v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
7686: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
7687: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
7688: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;

Line 7686: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;

7682: FROM JAI_PO_LINE_LOCATIONS
7683: WHERE line_location_id=c_line_location_id;
7684:
7685: v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
7686: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
7687: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
7688: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
7690: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;

Line 7687: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;

7683: WHERE line_location_id=c_line_location_id;
7684:
7685: v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
7686: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
7687: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
7688: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
7690: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
7691: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;

Line 7688: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;

7684:
7685: v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
7686: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
7687: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
7688: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
7690: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
7691: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
7692:

Line 7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;

7685: v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;
7686: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
7687: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
7688: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
7690: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
7691: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
7692:
7693: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;

Line 7690: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;

7686: v_po_hdr_id PO_DISTRIBUTIONS_ALL.Po_Header_Id%TYPE;
7687: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
7688: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
7690: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
7691: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
7692:
7693: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
7694:

Line 7691: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;

7687: v_cre_dt PO_DISTRIBUTIONS_ALL.Creation_Date%TYPE;
7688: v_cre_by PO_DISTRIBUTIONS_ALL.Created_By%TYPE;
7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
7690: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
7691: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
7692:
7693: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
7694:
7695: v_type_lookup_code po_headers_all.type_lookup_code%TYPE;

Line 7693: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;

7689: v_last_upd_dt PO_DISTRIBUTIONS_ALL.Last_Update_Date%TYPE ;
7690: v_last_upd_by PO_DISTRIBUTIONS_ALL.Last_Updated_By%TYPE;
7691: v_last_upd_login PO_DISTRIBUTIONS_ALL.Last_Update_Login%TYPE;
7692:
7693: v_line_location_id PO_DISTRIBUTIONS_ALL.line_location_id%TYPE;
7694:
7695: v_type_lookup_code po_headers_all.type_lookup_code%TYPE;
7696: v_Quot_Class_Code po_headers_all.Quotation_Class_Code%TYPE;
7697: v_Ship_Loc_Id po_headers_all.Ship_To_Location_Id%TYPE;