DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on PO_SESSION_GT_S

Line 4088: po_session_gt_s.NEXTVAL,

4084: char3, -- entity_pk3
4085: char4 -- entity_pk4
4086: )
4087: VALUES(
4088: po_session_gt_s.NEXTVAL,
4089: G_CHANGED_ENTTIES_ID,
4090: p_entity_name_tbl(i),
4091: p_pk1_tbl(i),
4092: p_pk2_tbl(i),

Line 4207: SELECT po_session_gt_s.NEXTVAL,

4203: char1, -- entity_pk1
4204: num1, -- lock_by_draft_id
4205: char5 -- lock_type
4206: )
4207: SELECT po_session_gt_s.NEXTVAL,
4208: G_LOCKS_REQUIRED_ID,
4209: G_LOCK_HEADER_ENTITY,
4210: draft.po_header_id,
4211: draft.draft_id,

Line 4368: SELECT po_session_gt_s.NEXTVAL,

4364: char1, -- entity_pk1
4365: num1, -- lock_by_draft_id
4366: char5 -- lock_type
4367: )
4368: SELECT po_session_gt_s.NEXTVAL,
4369: G_LOCKS_REQUIRED_ID,
4370: G_LOCK_HEADER_ENTITY,
4371: draft.po_header_id,
4372: draft.draft_id,

Line 4422: SELECT po_session_gt_s.NEXTVAL,

4418: char1, -- entity_pk1
4419: num1, -- lock_by_draft_id
4420: char5 -- lock_type
4421: )
4422: SELECT po_session_gt_s.NEXTVAL,
4423: G_LOCKS_REQUIRED_ID,
4424: G_LOCK_HEADER_ENTITY,
4425: draft.po_header_id,
4426: draft.draft_id,

Line 4530: SELECT po_session_gt_s.NEXTVAL,

4526: char1, -- entity_pk1
4527: num1, -- lock_by_draft_id
4528: char5 -- lock_type
4529: )
4530: SELECT po_session_gt_s.NEXTVAL,
4531: G_LOCKS_REQUIRED_ID,
4532: G_LOCK_LINE_ENTITY,
4533: draft.po_line_id,
4534: draft.draft_id,

Line 4732: SELECT po_session_gt_s.NEXTVAL,

4728: char1, -- entity_pk1
4729: num1, -- lock_by_draft_id
4730: char5 -- lock_type
4731: )
4732: SELECT po_session_gt_s.NEXTVAL,
4733: G_LOCKS_REQUIRED_ID,
4734: G_LOCK_LINE_ENTITY,
4735: draft.po_line_id,
4736: draft.draft_id,

Line 4800: SELECT po_session_gt_s.NEXTVAL,

4796: char1, -- entity_pk1
4797: num1, -- lock_by_draft_id
4798: char5 -- lock_type
4799: )
4800: SELECT po_session_gt_s.NEXTVAL,
4801: G_LOCKS_REQUIRED_ID,
4802: G_LOCK_LINE_ENTITY,
4803: draft.po_line_id,
4804: draft.draft_id,

Line 4857: SELECT po_session_gt_s.NEXTVAL,

4853: char1, -- entity_pk1
4854: num1, -- lock_by_draft_id
4855: char5 -- lock_type
4856: )
4857: SELECT po_session_gt_s.NEXTVAL,
4858: G_LOCKS_REQUIRED_ID,
4859: G_LOCK_LINE_ENTITY,
4860: draft.po_line_id,
4861: draft.draft_id,

Line 4924: SELECT po_session_gt_s.NEXTVAL,

4920: char1, -- entity_pk1
4921: num1, -- lock_by_draft_id
4922: char5 -- lock_type
4923: )
4924: SELECT po_session_gt_s.NEXTVAL,
4925: G_LOCKS_REQUIRED_ID,
4926: G_LOCK_LINE_ENTITY,
4927: draft.entity_id, -- po_lin
4928: draft.draft_id,

Line 4985: SELECT po_session_gt_s.NEXTVAL,

4981: char1, -- entity_pk1
4982: num1, -- lock_by_draft_id
4983: char5 -- lock_type
4984: )
4985: SELECT po_session_gt_s.NEXTVAL,
4986: G_LOCKS_REQUIRED_ID,
4987: G_LOCK_LINE_ENTITY,
4988: pol.po_line_id,
4989: p_draft_id,

Line 5015: SELECT po_session_gt_s.NEXTVAL,

5011: char1, -- entity_pk1
5012: num1, -- lock_by_draft_id
5013: char5 -- lock_type
5014: )
5015: SELECT po_session_gt_s.NEXTVAL,
5016: G_LOCKS_REQUIRED_ID,
5017: G_LOCK_LINE_ENTITY,
5018: pol.po_line_id,
5019: p_draft_id,

Line 5093: SELECT po_session_gt_s.NEXTVAL,

5089: char1, -- entity_pk1
5090: num1, -- lock_by_draft_id
5091: char5 -- lock_type
5092: )
5093: SELECT po_session_gt_s.NEXTVAL,
5094: G_LOCKS_REQUIRED_ID,
5095: G_LOCK_SHIPMENT_ENTITY,
5096: draft.line_location_id,
5097: draft.draft_id,

Line 5261: SELECT po_session_gt_s.NEXTVAL,

5257: char1, -- entity_pk1
5258: num1, -- lock_by_draft_id
5259: char5 -- lock_type
5260: )
5261: SELECT po_session_gt_s.NEXTVAL,
5262: G_LOCKS_REQUIRED_ID,
5263: G_LOCK_SHIPMENT_ENTITY,
5264: poll.line_location_id,
5265: p_draft_id,

Line 5359: SELECT po_session_gt_s.NEXTVAL,

5355: char1, -- entity_pk1
5356: num1, -- lock_by_draft_id
5357: char5 -- lock_type
5358: )
5359: SELECT po_session_gt_s.NEXTVAL,
5360: G_LOCKS_REQUIRED_ID,
5361: G_LOCK_DIST_ENTITY,
5362: draft.po_distribution_id,
5363: draft.draft_id,

Line 5519: SELECT po_session_gt_s.NEXTVAL,

5515: char1, -- entity_pk1
5516: num1, -- lock_by_draft_id
5517: char5 -- lock_type
5518: )
5519: SELECT po_session_gt_s.NEXTVAL,
5520: G_LOCKS_REQUIRED_ID,
5521: G_LOCK_DIST_ENTITY,
5522: pod.po_distribution_id,
5523: p_draft_id,

Line 5638: SELECT po_session_gt_s.NEXTVAL,

5634: char1, -- entity_pk1
5635: num1, -- lock_by_draft_id
5636: char5 -- lock_type
5637: )
5638: SELECT po_session_gt_s.NEXTVAL,
5639: G_LOCKS_REQUIRED_ID,
5640: G_LOCK_HEADER_ENTITY,
5641: draft.po_header_id,
5642: draft.draft_id,

Line 5885: SELECT po_session_gt_s.NEXTVAL,

5881: char1, -- entity_pk1
5882: num1, -- lock_by_draft_id
5883: char5 -- lock_type
5884: )
5885: SELECT po_session_gt_s.NEXTVAL,
5886: G_LOCKS_REQUIRED_ID,
5887: G_LOCK_HEADER_ENTITY,
5888: phda.po_header_id,
5889: p_draft_id,

Line 5939: SELECT po_session_gt_s.NEXTVAL,

5935: char1, -- entity_pk1
5936: num1, -- lock_by_draft_id
5937: char5 -- lock_type
5938: )
5939: SELECT po_session_gt_s.NEXTVAL,
5940: G_LOCKS_REQUIRED_ID,
5941: G_LOCK_HEADER_ENTITY,
5942: pohd.po_header_id,
5943: pohd.draft_id,

Line 6364: SELECT po_session_gt_s.NEXTVAL,

6360: char1, -- entity_pk1
6361: num1, -- lock_by_draft_id
6362: char5 -- lock_type
6363: )
6364: SELECT po_session_gt_s.NEXTVAL,
6365: G_LOCKS_REQUIRED_ID,
6366: G_LOCK_HEADER_ENTITY,
6367: draft.po_header_id,
6368: draft.draft_id,

Line 6498: SELECT po_session_gt_s.NEXTVAL,

6494: char2, -- entity_pk2
6495: num1, -- lock_by_draft_id
6496: char5 -- lock_type
6497: )
6498: SELECT po_session_gt_s.NEXTVAL,
6499: G_LOCKS_REQUIRED_ID,
6500: G_LOCK_ADDRESS_ENTITY,
6501: draft.po_header_id,
6502: draft.c_ext_attr39,

Line 6786: SELECT po_session_gt_s.NEXTVAL,

6782: char1, -- entity_pk1
6783: num1, -- lock_by_draft_id
6784: char5 -- lock_type
6785: )
6786: SELECT po_session_gt_s.NEXTVAL,
6787: G_LOCKS_REQUIRED_ID,
6788: G_LOCK_LINE_ENTITY,
6789: draft.po_line_id,
6790: draft.draft_id,

Line 7038: SELECT po_session_gt_s.NEXTVAL,

7034: char1, -- entity_pk1
7035: num1, -- lock_by_draft_id
7036: char5 -- lock_type
7037: )
7038: SELECT po_session_gt_s.NEXTVAL,
7039: G_LOCKS_REQUIRED_ID,
7040: G_LOCK_LINE_ENTITY,
7041: plbd.po_line_id,
7042: p_draft_id,

Line 7084: SELECT po_session_gt_s.NEXTVAL,

7080: char1, -- entity_pk1
7081: num1, -- lock_by_draft_id
7082: char5 -- lock_type
7083: )
7084: SELECT po_session_gt_s.NEXTVAL,
7085: G_LOCKS_REQUIRED_ID,
7086: G_LOCK_LINE_ENTITY,
7087: draft.po_line_id,
7088: draft.draft_id,

Line 7221: SELECT po_session_gt_s.NEXTVAL,

7217: char1, -- entity_pk1
7218: num1, -- lock_by_draft_id
7219: char5 -- lock_type
7220: )
7221: SELECT po_session_gt_s.NEXTVAL,
7222: G_LOCKS_REQUIRED_ID,
7223: G_LOCK_LINE_ENTITY,
7224: polext_base.po_line_id,
7225: polext_draft.draft_id,

Line 7275: SELECT po_session_gt_s.NEXTVAL,

7271: char1, -- entity_pk1
7272: num1, -- lock_by_draft_id
7273: char5 -- lock_type
7274: )
7275: SELECT po_session_gt_s.NEXTVAL,
7276: G_LOCKS_REQUIRED_ID,
7277: G_LOCK_LINE_ENTITY,
7278: polext_base.po_line_id,
7279: polext_draft.draft_id,

Line 7384: SELECT po_session_gt_s.NEXTVAL,

7380: char1, -- entity_pk1
7381: num1, -- lock_by_draft_id
7382: char5 -- lock_type
7383: )
7384: SELECT po_session_gt_s.NEXTVAL,
7385: G_LOCKS_REQUIRED_ID,
7386: G_LOCK_SHIPMENT_ENTITY,
7387: draft.line_location_id,
7388: draft.draft_id,

Line 7620: SELECT po_session_gt_s.NEXTVAL,

7616: char1, -- entity_pk1
7617: num1, -- lock_by_draft_id
7618: char5 -- lock_type
7619: )
7620: SELECT po_session_gt_s.NEXTVAL,
7621: G_LOCKS_REQUIRED_ID,
7622: G_LOCK_SHIPMENT_ENTITY,
7623: pllbd.line_location_id,
7624: p_draft_id,

Line 7657: SELECT po_session_gt_s.NEXTVAL,

7653: char1, -- entity_pk1
7654: num1, -- lock_by_draft_id
7655: char5 -- lock_type
7656: )
7657: SELECT po_session_gt_s.NEXTVAL,
7658: G_LOCKS_REQUIRED_ID,
7659: G_LOCK_SHIPMENT_ENTITY,
7660: draft.line_location_id,
7661: draft.draft_id,

Line 9504: SELECT po_session_gt_s.NEXTVAL,

9500: char1, -- entity_pk1
9501: num1, -- lock_by_draft_id
9502: char5 -- lock_type
9503: )
9504: SELECT po_session_gt_s.NEXTVAL,
9505: G_LOCKS_REQUIRED_ID,
9506: G_LOCK_EXHIBIT_ENTITY,
9507: draft.po_exhibit_details_id, -- po_exhibit_details_id
9508: draft.draft_id,