APPS.XNP_WF_SYNC dependencies on XNP_SYNC_REGISTRATION_S

Line 226: lv_sync_label xnp_sync_registration.sync_label%TYPE;

222: lv_order_id NUMBER;
223: lv_line_item_id NUMBER;
224: lv_wi_instance_id NUMBER;
225: lv_message_id NUMBER;
226: lv_sync_label xnp_sync_registration.sync_label%TYPE;
227:
228: e_SyncException EXCEPTION;
229:
230: BEGIN

Line 313: lv_status xnp_sync_registration.status%TYPE;

309: ,po_error_msg OUT NOCOPY VARCHAR2
310: )
311: IS
312:
313: lv_status xnp_sync_registration.status%TYPE;
314: lv_error_code NUMBER;
315: lv_error_msg VARCHAR2(300);
316:
317: -- Cursor to obtain a lock on the XNP_SYNC_REGISTRATION table

Line 368: lv_status xnp_sync_registration.status%TYPE;

364: ,po_error_msg OUT NOCOPY VARCHAR2
365: )
366: IS
367:
368: lv_status xnp_sync_registration.status%TYPE;
369: lv_error_code NUMBER;
370: lv_error_msg VARCHAR2(300);
371:
372: -- Cursor to obtain a lock on the XNP_SYNC_REGISTRATION table

Line 427: lv_sync_registration_id xnp_sync_registration.sync_registration_id%TYPE;

423: ,po_error_code OUT NOCOPY NUMBER
424: ,po_error_msg OUT NOCOPY VARCHAR2
425: )
426: IS
427: lv_sync_registration_id xnp_sync_registration.sync_registration_id%TYPE;
428: lv_sync_label xnp_sync_registration.sync_label%TYPE;
429: lv_range_count NUMBER := 0;
430: lv_error_code NUMBER := 0;
431: lv_error_msg VARCHAR2(300);

Line 428: lv_sync_label xnp_sync_registration.sync_label%TYPE;

424: ,po_error_msg OUT NOCOPY VARCHAR2
425: )
426: IS
427: lv_sync_registration_id xnp_sync_registration.sync_registration_id%TYPE;
428: lv_sync_label xnp_sync_registration.sync_label%TYPE;
429: lv_range_count NUMBER := 0;
430: lv_error_code NUMBER := 0;
431: lv_error_msg VARCHAR2(300);
432: e_SyncInsertException EXCEPTION;

Line 494: SELECT xnp_sync_registration_s.NEXTVAL

490: END LOOP;
491:
492: -- Get the next sequence number value
493:
494: SELECT xnp_sync_registration_s.NEXTVAL
495: INTO lv_sync_registration_id
496: FROM dual;
497:
498: -- Insert a Sync Registration

Line 552: l_sync_label xnp_sync_registration.sync_label%TYPE;

548: ,po_error_msg OUT NOCOPY VARCHAR2
549: ,po_result OUT NOCOPY VARCHAR2
550: )
551: IS
552: l_sync_label xnp_sync_registration.sync_label%TYPE;
553: l_status xnp_sync_registration.status%TYPE;
554: l_max_participants xnp_sync_registration.max_participants%TYPE;
555: l_parties_not_in_sync xnp_sync_registration.parties_not_in_sync%TYPE;
556: l_sync_reqd_flag VARCHAR2(100);

Line 553: l_status xnp_sync_registration.status%TYPE;

549: ,po_result OUT NOCOPY VARCHAR2
550: )
551: IS
552: l_sync_label xnp_sync_registration.sync_label%TYPE;
553: l_status xnp_sync_registration.status%TYPE;
554: l_max_participants xnp_sync_registration.max_participants%TYPE;
555: l_parties_not_in_sync xnp_sync_registration.parties_not_in_sync%TYPE;
556: l_sync_reqd_flag VARCHAR2(100);
557: l_order_id NUMBER;

Line 884: lv_sync_label xnp_sync_registration.sync_label%TYPE;

880: ,x_error_code OUT NOCOPY NUMBER
881: ,x_error_message OUT NOCOPY VARCHAR2
882: )
883: IS
884: lv_sync_label xnp_sync_registration.sync_label%TYPE;
885: lv_error_code NUMBER;
886: lv_error_msg VARCHAR2(300);
887:
888: e_Exception EXCEPTION;

Line 896: -- Update the XNP_SYNC_REGISTRATION status to ERROR

892: -- Get the SYNC_LABEL from the Event Message
893: --
894: lv_sync_label := p_msg_header.reference_id;
895:
896: -- Update the XNP_SYNC_REGISTRATION status to ERROR
897: --
898: Update_Sync_Status (pp_sync_label => lv_sync_label
899: ,pp_status => gv_SYNC_ERROR_STATUS
900: ,po_error_code => lv_error_code

Line 930: lv_sync_label xnp_sync_registration.sync_label%TYPE;

926: ,x_error_code OUT NOCOPY NUMBER
927: ,x_error_message OUT NOCOPY VARCHAR2)
928:
929: IS
930: lv_sync_label xnp_sync_registration.sync_label%TYPE;
931: lv_error_code NUMBER;
932: lv_error_msg VARCHAR2(300);
933:
934: e_Exception EXCEPTION;

Line 942: -- Update the XNP_SYNC_REGISTRATION status to ERROR

938: -- Get the SYNC_LABEL from the Event Message
939: --
940: lv_sync_label := p_msg_header.reference_id;
941:
942: -- Update the XNP_SYNC_REGISTRATION status to ERROR
943: --
944: Update_Sync_Status (pp_sync_label => lv_sync_label
945: ,pp_status => gv_SYNC_TIMEOUT
946: ,po_error_code => lv_error_code

Line 1018: l_sync_label xnp_sync_registration.sync_label%TYPE;

1014: ,p_itemkey IN VARCHAR2
1015: ,p_actid IN NUMBER
1016: ) RETURN VARCHAR2
1017: IS
1018: l_sync_label xnp_sync_registration.sync_label%TYPE;
1019: l_parties_not_in_sync xnp_sync_registration.parties_not_in_sync%TYPE;
1020: l_max_participants xnp_sync_registration.max_participants%TYPE;
1021: l_order_id NUMBER;
1022: l_line_item_id NUMBER;