APPS.PO_WAGE_DETERMINATION_ONLINE dependencies on PO_WAGE_DETERMINATION

Line 1: PACKAGE BODY PO_WAGE_DETERMINATION_ONLINE AS

1: PACKAGE BODY PO_WAGE_DETERMINATION_ONLINE AS
2: /* $Header: PO_WAGE_DETERMINATION_ONLINE.plb 120.3.12020000.6 2013/03/06 06:17:49 harchand noship $ */
3:
4:
5: FUNCTION get_lookup_value (p_lookup_code VARCHAR2) RETURN VARCHAR2 IS

Line 2: /* $Header: PO_WAGE_DETERMINATION_ONLINE.plb 120.3.12020000.6 2013/03/06 06:17:49 harchand noship $ */

1: PACKAGE BODY PO_WAGE_DETERMINATION_ONLINE AS
2: /* $Header: PO_WAGE_DETERMINATION_ONLINE.plb 120.3.12020000.6 2013/03/06 06:17:49 harchand noship $ */
3:
4:
5: FUNCTION get_lookup_value (p_lookup_code VARCHAR2) RETURN VARCHAR2 IS
6:

Line 10: WHERE lookup_type = 'PO_WAGE_DETERMINATION_STATUS'

6:
7: CURSOR c_get_lookup_value IS
8: SELECT meaning
9: FROM fnd_lookups
10: WHERE lookup_type = 'PO_WAGE_DETERMINATION_STATUS'
11: AND (SYSDATE BETWEEN start_date_active AND Nvl(end_date_active,SYSDATE+1))
12: AND lookup_code = p_lookup_code ;
13:
14: l_lookup_value VARCHAR2(30):= NULL ;

Line 203: INSERT INTO po_wage_determination

199: IF x_row_id is not null THEN
200:
201: l_lookup_code:=get_lookup_value('COMPLETE');
202:
203: INSERT INTO po_wage_determination
204: (
205: id ,
206: doc_id ,
207: doc_type ,

Line 220: VALUES (po_wage_determination_s.NEXTVAL,

216: creation_date ,
217: created_by ,
218: last_update_login
219: )
220: VALUES (po_wage_determination_s.NEXTVAL,
221: p_document_id,
222: p_document_type,
223: p_draft_id,
224: p_input_url,

Line 242: INSERT INTO po_wage_determination

238: ELSE
239:
240: l_lookup_code:=get_lookup_value('FAIL');
241:
242: INSERT INTO po_wage_determination
243: (
244: id ,
245: doc_id ,
246: doc_type ,

Line 259: VALUES (po_wage_determination_s.NEXTVAL,

255: creation_date ,
256: created_by ,
257: last_update_login
258: )
259: VALUES (po_wage_determination_s.NEXTVAL,
260: p_document_id,
261: p_document_type,
262: p_draft_id,
263: p_input_url,

Line 287: FUNCTION po_wage_determination_receive(

283: EXCEPTION WHEN OTHERS THEN
284: NULL;
285: END GET_WDOL_STATEMENT;
286:
287: FUNCTION po_wage_determination_receive(
288: p_subscription_guid IN RAW
289: ,p_event IN OUT NOCOPY wf_event_t)
290: RETURN VARCHAR2 IS
291: l_doc_id NUMBER;

Line 451: INSERT INTO po_wage_determination

447: IF x_row_id is not null THEN
448:
449: l_lookup_code:=get_lookup_value('COMPLETE');
450:
451: INSERT INTO po_wage_determination
452: (
453: id ,
454: doc_id ,
455: doc_type ,

Line 468: VALUES (po_wage_determination_s.NEXTVAL,

464: creation_date ,
465: created_by ,
466: last_update_login
467: )
468: VALUES (po_wage_determination_s.NEXTVAL,
469: l_doc_id,
470: l_doc_type,
471: l_draft_id,
472: l_input_url,

Line 488: INSERT INTO po_wage_determination

484: ELSE
485:
486: l_lookup_code:=get_lookup_value('FAIL');
487:
488: INSERT INTO po_wage_determination
489: (
490: id ,
491: doc_id ,
492: doc_type ,

Line 505: VALUES (po_wage_determination_s.NEXTVAL,

501: creation_date ,
502: created_by ,
503: last_update_login
504: )
505: VALUES (po_wage_determination_s.NEXTVAL,
506: l_doc_id,
507: l_doc_type,
508: l_draft_id,
509: l_input_url,

Line 527: END po_wage_determination_receive;

523:
524: COMMIT;
525:
526: RETURN 'SUCCESS';
527: END po_wage_determination_receive;
528:
529: PROCEDURE validate_wage_determination(
530: x_result OUT NOCOPY VARCHAR2,
531: x_error_code OUT NOCOPY VARCHAR2,

Line 622: FROM po_wage_determination

618: l_curr_row_exists VARCHAR2(1):='N';
619:
620: CURSOR c_get_current_row IS
621: SELECT 'Y'
622: FROM po_wage_determination
623: WHERE doc_id = p_document_id
624: AND doc_type = p_document_type
625: AND Nvl(draft_id,-1) = Nvl(p_draft_id,-1);
626:

Line 639: INSERT INTO po_wage_determination

635: IF l_curr_row_exists = 'N' THEN
636:
637:
638:
639: INSERT INTO po_wage_determination
640: (
641: id ,
642: doc_id ,
643: doc_type ,

Line 656: VALUES (po_wage_determination_s.NEXTVAL,

652: creation_date ,
653: created_by ,
654: last_update_login
655: )
656: VALUES (po_wage_determination_s.NEXTVAL,
657: p_document_id,
658: p_document_type,
659: p_draft_id,
660: null,

Line 732: END PO_WAGE_DETERMINATION_ONLINE;

728: RETURN 'N';
729: END IS_ACTION_VALID;
730:
731:
732: END PO_WAGE_DETERMINATION_ONLINE;