APPS.IGS_SC_BULK_ASSIGN dependencies on IGS_SC_PER_ATTR_VALS

Line 258: FROM IGS_SC_PER_ATTR_VALS

254: SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE+1);
255:
256: CURSOR IGS_SC_DUP_C(prsnId NUMBER,usrAttrId NUMBER,usrAttrVal VARCHAR2) IS
257: SELECT 1
258: FROM IGS_SC_PER_ATTR_VALS
259: WHERE person_id = prsnId AND
260: user_attrib_id = usrAttrId AND
261: user_attrib_value = usrAttrVal;
262:

Line 474: /*Now iterate through Locations array to insert record into igs_sc_per_attr_vals */

470: END IF; -- l_org_unit_array
471:
472: IF l_locations_array IS NOT NULL THEN
473:
474: /*Now iterate through Locations array to insert record into igs_sc_per_attr_vals */
475: FOR i IN 1..l_locations_array.COUNT
476: LOOP
477: /* First check that user does not have this attribute already assigned */
478: OPEN IGS_SC_DUP_C(r_rec_query.Person_id,6,l_locations_array(i));

Line 488: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(

484: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
485: END IF;
486:
487: IF IGS_SC_DUP_C%NOTFOUND THEN
488: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(
489: x_rowid => l_rowId,
490: x_person_id =>r_rec_query.Person_id,
491: x_user_attrib_id => 6,
492: x_user_attrib_value => l_locations_array(i)

Line 500: /*Now iterate through PgmTypes array to insert record into igs_sc_per_attr_vals */

496: END LOOP;
497: END IF; -- l_locations_array
498:
499: IF l_pgmtypes_array IS NOT NULL THEN
500: /*Now iterate through PgmTypes array to insert record into igs_sc_per_attr_vals */
501: for i IN 1..l_pgmtypes_array.COUNT
502: LOOP
503: OPEN IGS_SC_DUP_C(r_rec_query.Person_id,7,l_pgmtypes_array(i));
504: FETCH IGS_SC_DUP_C INTO l_DupId;

Line 513: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(

509: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
510: END IF;
511:
512: IF IGS_SC_DUP_C%NOTFOUND THEN
513: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(
514: x_rowid => l_rowId,
515: x_person_id =>r_rec_query.Person_id,
516: x_user_attrib_id => 7,
517: x_user_attrib_value => l_pgmtypes_array(i)

Line 525: /*Now iterate through Unit Md array to insert record into igs_sc_per_attr_vals */

521: END LOOP;
522: END IF; -- l_pgmtypes_array
523:
524: IF l_unitmd_array IS NOT NULL THEN
525: /*Now iterate through Unit Md array to insert record into igs_sc_per_attr_vals */
526: FOR i IN 1..l_unitmd_array.COUNT
527: LOOP
528: OPEN IGS_SC_DUP_C(r_rec_query.Person_id,8,l_unitmd_array(i));
529: FETCH IGS_SC_DUP_C INTO l_DupId;

Line 538: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(

534: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
535: END IF;
536:
537: IF IGS_SC_DUP_C%NOTFOUND THEN
538: IGS_SC_PER_ATTR_VALS_PKG.INSERT_ROW(
539: x_rowid => l_rowId,
540: x_person_id =>r_rec_query.Person_id,
541: x_user_attrib_id => 8,
542: x_user_attrib_value => l_unitmd_array(i)