DBA Data[Home] [Help]

APPS.ZPB_DC_WF dependencies on ZPB_DC_WF_PROCESSES_S

Line 671: SELECT ZPB_DC_WF_PROCESSES_S.nextval

667: -- Initialize the parameters
668: l_item_type := 'ZPBDC' ;
669:
670:
671: SELECT ZPB_DC_WF_PROCESSES_S.nextval
672: INTO l_sequence
673: FROM dual;
674:
675: SELECT template_name

Line 1509: SELECT ZPB_DC_WF_PROCESSES_S.nextval

1505: END IF;
1506: END IF;
1507:
1508: -- Create a meaningful item key for dev use--
1509: SELECT ZPB_DC_WF_PROCESSES_S.nextval
1510: INTO l_sequence
1511: FROM dual;
1512:
1513: IF (l_object_type = 'E') THEN

Line 2505: SELECT ZPB_DC_WF_PROCESSES_S.nextval

2501: FROM zpb_dc_objects obj, fnd_user fnd
2502: WHERE obj.object_id = p_object_id
2503: AND obj.object_user_id = fnd.user_id;
2504:
2505: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2506: INTO l_sequence
2507: FROM dual;
2508:
2509: l_substr_templ_name := substr(l_template_name,1,140);

Line 2695: SELECT ZPB_DC_WF_PROCESSES_S.nextval

2691: l_commit := FND_API.G_FALSE;
2692: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
2693:
2694:
2695: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2696: INTO l_item_key
2697: FROM dual;
2698:
2699: SELECT nvl(description,user_name)

Line 2716: SELECT ZPB_DC_WF_PROCESSES_S.nextval

2712: INTO l_from_name
2713: FROM fnd_user
2714: WHERE user_id= p_approver_user_id;
2715:
2716: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2717: INTO l_sequence
2718: FROM dual;
2719:
2720: l_substr_templ_name := substr(l_template_name,1,140);