APPS.AMW_AUDIT_PROCEDURES_PVT dependencies on AMW_AP_STEPS_VL

Line 2476: l_row_id amw_ap_steps_vl.row_id%TYPE;

2472: l_api_name CONSTANT VARCHAR2(30) := 'copy_audit_steps';
2473: l_api_version CONSTANT NUMBER := 1.0;
2474: l_object_version_number NUMBER := 1;
2475: l_from_rev_num NUMBER := 1;
2476: l_row_id amw_ap_steps_vl.row_id%TYPE;
2477: l_id NUMBER;
2478: CURSOR steps_b IS SELECT
2479: AMW_AP_STEPS_S.NEXTVAL STEP_ID,
2480: SEQNUM,

Line 2510: FROM AMW_AP_STEPS_VL step, AMW_AUDIT_PROCEDURES_B ap

2506: step.REQUESTOR_ID,
2507: step.NAME,
2508: step.DESCRIPTION,
2509: step.CSEQNUM
2510: FROM AMW_AP_STEPS_VL step, AMW_AUDIT_PROCEDURES_B ap
2511:
2512: WHERE ap.audit_procedure_rev_id = x_from_ap_rev_id and
2513: ap.audit_procedure_id = step.audit_procedure_id and
2514: ap.audit_procedure_rev_num >= step.from_rev_num and

Line 2987: FROM amw_ap_steps_vl b

2983: b.samplesize,
2984: b.from_rev_num,
2985: b.to_rev_num,
2986: b.object_version_number
2987: FROM amw_ap_steps_vl b
2988: WHERE b.cseqnum = c_step_num
2989: AND b.audit_procedure_id = c_ap_id
2990: AND b.from_rev_num = c_from_ap_rev_num;
2991:

Line 3001: FROM amw_ap_steps_vl b

2997: b.cseqnum,
2998: b.from_rev_num,
2999: b.to_rev_num,
3000: b.object_version_number
3001: FROM amw_ap_steps_vl b
3002: WHERE b.cseqnum = c_step_num
3003: AND b.audit_procedure_id = c_ap_id
3004: AND b.to_rev_num is null and b.from_rev_num <> c_from_ap_rev_num;
3005:

Line 3018: lx_rowid amw_ap_steps_vl.row_id%type;

3014: l_api_name CONSTANT VARCHAR2(30) := 'Insert_AP_Step';
3015: l_api_version_number CONSTANT NUMBER := 1.0;
3016:
3017: l_ap_step_id number;
3018: lx_rowid amw_ap_steps_vl.row_id%type;
3019: l_ap_rev_num number;
3020: lx_step_rec c_step_exists%rowtype;
3021: lx_prev_step_rec c_step_exists_for_prev_rev%rowtype;
3022: begin