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.PO_DOCUMENT_CHECKS_PVT dependencies on PO_SESSION_GT

Line 16214: l_procedure_id PO_SESSION_GT.key%TYPE;

16210: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
16211:
16212: -- bug3592160 START
16213: l_header_id PO_TBL_NUMBER;
16214: l_procedure_id PO_SESSION_GT.key%TYPE;
16215: -- bug3592160 END
16216:
16217: --
16218: l_role PO_DRAFTS.owner_role%TYPE := NVL(p_role, PO_GLOBAL.g_ROLE_BUYER);

Line 16264: INSERT INTO PO_SESSION_GT

16260: -- BULK UPDATE
16261: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
16262:
16263: FORALL i IN 1..p_count
16264: INSERT INTO PO_SESSION_GT
16265: ( key,
16266: num1
16267: )
16268: SELECT l_procedure_id,

Line 16349: -- Remove everything that has been inserted into PO_SESSION_GT

16345:
16346: END LOOP;
16347:
16348: -- bug3592160 START
16349: -- Remove everything that has been inserted into PO_SESSION_GT
16350: DELETE FROM po_session_gt
16351: WHERE key = l_procedure_id;
16352: -- bug3592160 END
16353:

Line 16350: DELETE FROM po_session_gt

16346: END LOOP;
16347:
16348: -- bug3592160 START
16349: -- Remove everything that has been inserted into PO_SESSION_GT
16350: DELETE FROM po_session_gt
16351: WHERE key = l_procedure_id;
16352: -- bug3592160 END
16353:
16354: --

Line 16448: l_procedure_id PO_SESSION_GT.key%TYPE;

16444: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
16445:
16446: -- bug3592160 START
16447: l_header_id PO_TBL_NUMBER;
16448: l_procedure_id PO_SESSION_GT.key%TYPE;
16449: -- bug3592160 END
16450:
16451: BEGIN
16452:

Line 16490: INSERT INTO PO_SESSION_GT

16486: -- BULK UPDATE
16487: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
16488:
16489: FORALL i IN 1..p_count
16490: INSERT INTO PO_SESSION_GT
16491: ( key,
16492: num1
16493: )
16494: SELECT l_procedure_id,

Line 16556: -- Remove everything that has been inserted into PO_SESSION_GT

16552:
16553: END LOOP;
16554:
16555: -- bug3592160 START
16556: -- Remove everything that has been inserted into PO_SESSION_GT
16557: DELETE FROM po_session_gt
16558: WHERE key = l_procedure_id;
16559: -- bug3592160 END
16560:

Line 16557: DELETE FROM po_session_gt

16553: END LOOP;
16554:
16555: -- bug3592160 START
16556: -- Remove everything that has been inserted into PO_SESSION_GT
16557: DELETE FROM po_session_gt
16558: WHERE key = l_procedure_id;
16559: -- bug3592160 END
16560:
16561: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 16626: l_procedure_id PO_SESSION_GT.key%TYPE;

16622: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
16623:
16624: -- bug3592160 START
16625: l_header_id PO_TBL_NUMBER;
16626: l_procedure_id PO_SESSION_GT.key%TYPE;
16627: -- bug3592160 END
16628:
16629: BEGIN
16630:

Line 16668: INSERT INTO PO_SESSION_GT

16664: -- BULK UPDATE
16665: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
16666:
16667: FORALL i IN 1..p_count
16668: INSERT INTO PO_SESSION_GT
16669: ( key,
16670: num1
16671: )
16672: SELECT l_procedure_id,

Line 16725: -- Remove everything that has been inserted into PO_SESSION_GT

16721:
16722: END LOOP;
16723:
16724: -- bug3592160 START
16725: -- Remove everything that has been inserted into PO_SESSION_GT
16726: DELETE FROM po_session_gt
16727: WHERE key = l_procedure_id;
16728: -- bug3592160 END
16729:

Line 16726: DELETE FROM po_session_gt

16722: END LOOP;
16723:
16724: -- bug3592160 START
16725: -- Remove everything that has been inserted into PO_SESSION_GT
16726: DELETE FROM po_session_gt
16727: WHERE key = l_procedure_id;
16728: -- bug3592160 END
16729:
16730: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 18474: -- PO_SESSION_GT column mapping

18470: -- Collect this information into the scratchpad,
18471: -- along with the info we need for error reporting.
18472:
18473: -----------------------------------------
18474: -- PO_SESSION_GT column mapping
18475: --
18476: -- num1 line_num
18477: -- num2 shipment_num
18478: -- num3 distribution_num

Line 18482: SELECT PO_SESSION_GT_S.nextval

18478: -- num3 distribution_num
18479: -- char1 period_name
18480: -----------------------------------------
18481:
18482: SELECT PO_SESSION_GT_S.nextval
18483: INTO l_dates_key
18484: FROM DUAL
18485: ;
18486:

Line 18490: INSERT INTO PO_SESSION_GT

18486:
18487: l_progress := '220';
18488:
18489: FORALL i IN 1 .. l_period_name_tbl.COUNT
18490: INSERT INTO PO_SESSION_GT
18491: ( key
18492: , num1 -- line_num
18493: , num2 -- shipment_num
18494: , num3 -- distribution_num

Line 18557: FROM PO_SESSION_GT DATES

18553: , 1
18554: , 240
18555: )
18556: , l_msg_name
18557: FROM PO_SESSION_GT DATES
18558: WHERE DATES.key = l_dates_key
18559: AND DATES.char1 IS NULL -- period_name not found
18560: ;
18561:

Line 23098: INSERT INTO po_session_gt

23094:
23095:
23096: /*Collecting the Charge Accounts, LOAs and the ACRN values populated
23097: into session gt for validation. */
23098: INSERT INTO po_session_gt
23099: (KEY,num1,char1,char2,char3,char5
23100: )
23101: SELECT l_key,
23102: po_distribution_id,

Line 23202: FROM po_session_gt

23198: THEN l_loas
23199: ELSE l_charge_acc
23200: END ) c_l,
23201: CHAR3 Gen_value
23202: FROM po_session_gt
23203: where KEY = l_key
23204: )
23205: CONNECT BY NOCYCLE prior acrn=acrn
23206: AND prior Gen_value <> Gen_value

Line 23304: FROM po_session_gt

23300: THEN l_loas
23301: ELSE l_charge_acc
23302: END) c_l,
23303: char5 acrn
23304: FROM po_session_gt
23305: WHERE char5 IS NOT NULL
23306: and KEY = l_key
23307: )-- This part of the sql selects the gen value and identifies it as loa/ca
23308: CONNECT BY NOCYCLE prior gen_val=gen_val

Line 25779: l_procedure_id PO_SESSION_GT.key%TYPE;

25775: l_api_name CONSTANT varchar2(40) := 'check_po_mipr_reference';
25776: d_module VARCHAR2(70) := g_log_head||l_api_name;
25777: d_progress NUMBER;
25778:
25779: l_procedure_id PO_SESSION_GT.key%TYPE;
25780: l_textline po_online_report_text.text_line%TYPE := NULL;
25781: l_mipr_own_ref_exists VARCHAR2(1);
25782: l_mipr_others_ref_exists VARCHAR2(1);
25783: l_non_mipr_ref_exists VARCHAR2(1);

Line 25798: INSERT INTO po_session_gt(

25794: PO_LOG.proc_begin(d_module, 'l_procedure_id', l_procedure_id);
25795: END IF;
25796:
25797: ---Collect the MIPR references on the Award
25798: INSERT INTO po_session_gt(
25799: KEY, -- Unique Key for procedure
25800: num1, -- PO po_distribution_id
25801: num2, -- MIPR distribution_id
25802: num3, -- MIPR requisition_header_id

Line 25849: FROM po_session_gt

25845: -- Checks if MIPR Own reference exists on Award
25846: BEGIN
25847: SELECT 'Y'
25848: INTO l_mipr_own_ref_exists
25849: FROM po_session_gt
25850: WHERE KEY = l_procedure_id
25851: AND char1 = 'MIPR_OWN'
25852: AND ROWNUM = 1;
25853:

Line 25864: FROM po_session_gt

25860: -- Checks if MIPR Others reference exists on Award
25861: BEGIN
25862: SELECT 'Y'
25863: INTO l_mipr_others_ref_exists
25864: FROM po_session_gt
25865: WHERE KEY = l_procedure_id
25866: AND char1 = 'MIPR_OTHERS'
25867: AND ROWNUM = 1;
25868: EXCEPTION

Line 25886: FROM po_session_gt GT

25882: WHERE POD.po_header_id = p_document_id
25883: AND req_distribution_id IS NOT NULL --PO Dist has a req reference
25884: AND NOT EXISTS(
25885: SELECT 1
25886: FROM po_session_gt GT
25887: WHERE GT.key = l_procedure_id
25888: AND GT.num1 = POD.po_distribution_id)); --PO Dist does not have MIPR Ref
25889: EXCEPTION
25890: WHEN NO_DATA_FOUND THEN

Line 26022: FROM po_session_gt

26018: 'W'
26019: FROM dual
26020: WHERE EXISTS(
26021: SELECT 1
26022: FROM po_session_gt
26023: WHERE key = l_procedure_id
26024: AND char1 = 'MIPR_OWN'
26025: HAVING Count(DISTINCT num3) > 1);--requisition_header_id of referenced MIPR
26026:

Line 26062: FROM po_session_gt GT

26058: 'LINE_NUM', GT.char4,
26059: 'SHIP_NUM', GT.char5,
26060: 'DIST_NUM', GT.char6),
26061: 'PO_MIPR_MULTI_ASST_OFF_REF'
26062: FROM po_session_gt GT
26063: WHERE key = l_procedure_id
26064: AND char1 = 'MIPR_OWN'
26065: AND EXISTS(
26066: SELECT 1

Line 26067: FROM po_session_gt

26063: WHERE key = l_procedure_id
26064: AND char1 = 'MIPR_OWN'
26065: AND EXISTS(
26066: SELECT 1
26067: FROM po_session_gt
26068: WHERE key = l_procedure_id
26069: AND char1 = 'MIPR_OWN'
26070: HAVING Count(DISTINCT num4) > 1);--clm_assist_office of referenced MIPR
26071:

Line 26107: FROM po_session_gt GT

26103: 'LINE_NUM', GT.char4,
26104: 'SHIP_NUM', GT.char5,
26105: 'DIST_NUM', GT.char6),
26106: 'PO_MIPR_OWN_AND_PR_REF'
26107: FROM po_session_gt GT
26108: WHERE key = l_procedure_id
26109: AND char1 = 'MIPR_OWN'
26110: AND (l_mipr_others_ref_exists = 'Y' OR l_non_mipr_ref_exists = 'Y');
26111:

Line 26147: FROM po_session_gt GT

26143: 'LINE_NUM', GT.char4,
26144: 'SHIP_NUM', GT.char5,
26145: 'DIST_NUM', GT.char6),
26146: 'PO_MIPR_MULTI_OBLIG_REF'
26147: FROM po_session_gt GT
26148: WHERE key = l_procedure_id
26149: AND char1 = 'MIPR_OWN'
26150: AND char2 = 'DIRECT_CITE' -- Direct Cite clm_mipr_obligation_type of referenced MIPR
26151: AND EXISTS(

Line 26153: FROM po_session_gt

26149: AND char1 = 'MIPR_OWN'
26150: AND char2 = 'DIRECT_CITE' -- Direct Cite clm_mipr_obligation_type of referenced MIPR
26151: AND EXISTS(
26152: SELECT 1
26153: FROM po_session_gt
26154: WHERE key = l_procedure_id
26155: AND char1 = 'MIPR_OWN'
26156: AND char2 = 'REIMBURSEMENT'); -- Reimbursement clm_mipr_obligation_type
26157:

Line 26224: FROM po_session_gt

26220: 'W'
26221: FROM dual
26222: WHERE EXISTS(
26223: SELECT 1
26224: FROM po_session_gt
26225: WHERE key = l_procedure_id
26226: AND char1 = 'MIPR_OTHERS'
26227: HAVING Count(DISTINCT num5) > 1);--clm_req_office of the referenced MIPR
26228:

Line 26236: DELETE FROM po_session_gt

26232: -- End: MIPR Other reference checks
26233:
26234: d_progress := 130;
26235: -- Delete the records from session table
26236: DELETE FROM po_session_gt
26237: WHERE key = l_procedure_id;
26238:
26239: x_return_status := FND_API.G_RET_STS_SUCCESS;
26240: