APPS.GMIVDBL dependencies on IC_ITEM_CPG

Line 1026: FUNCTION ic_item_cpg_insert

1022: GMIGUTL.DB_ERRMSG:= SQLERRM;
1023: RETURN FALSE;
1024: END ic_lots_mst_select;
1025:
1026: FUNCTION ic_item_cpg_insert
1027: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
1028: RETURN BOOLEAN
1029: IS
1030: BEGIN

Line 1027: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)

1023: RETURN FALSE;
1024: END ic_lots_mst_select;
1025:
1026: FUNCTION ic_item_cpg_insert
1027: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
1028: RETURN BOOLEAN
1029: IS
1030: BEGIN
1031: /* Copy input to output */

Line 1033: x_ic_item_cpg_row := p_ic_item_cpg_row;

1029: IS
1030: BEGIN
1031: /* Copy input to output */
1032:
1033: x_ic_item_cpg_row := p_ic_item_cpg_row;
1034:
1035: INSERT INTO ic_item_cpg
1036: ( item_id
1037: , ic_matr_days

Line 1035: INSERT INTO ic_item_cpg

1031: /* Copy input to output */
1032:
1033: x_ic_item_cpg_row := p_ic_item_cpg_row;
1034:
1035: INSERT INTO ic_item_cpg
1036: ( item_id
1037: , ic_matr_days
1038: , ic_hold_days
1039: , created_by

Line 1046: ( x_ic_item_cpg_row.item_id

1042: , last_update_date
1043: , last_update_login
1044: )
1045: VALUES
1046: ( x_ic_item_cpg_row.item_id
1047: , x_ic_item_cpg_row.ic_matr_days
1048: , x_ic_item_cpg_row.ic_hold_days
1049: , x_ic_item_cpg_row.created_by
1050: , x_ic_item_cpg_row.creation_date

Line 1047: , x_ic_item_cpg_row.ic_matr_days

1043: , last_update_login
1044: )
1045: VALUES
1046: ( x_ic_item_cpg_row.item_id
1047: , x_ic_item_cpg_row.ic_matr_days
1048: , x_ic_item_cpg_row.ic_hold_days
1049: , x_ic_item_cpg_row.created_by
1050: , x_ic_item_cpg_row.creation_date
1051: , x_ic_item_cpg_row.last_updated_by

Line 1048: , x_ic_item_cpg_row.ic_hold_days

1044: )
1045: VALUES
1046: ( x_ic_item_cpg_row.item_id
1047: , x_ic_item_cpg_row.ic_matr_days
1048: , x_ic_item_cpg_row.ic_hold_days
1049: , x_ic_item_cpg_row.created_by
1050: , x_ic_item_cpg_row.creation_date
1051: , x_ic_item_cpg_row.last_updated_by
1052: , x_ic_item_cpg_row.last_update_date

Line 1049: , x_ic_item_cpg_row.created_by

1045: VALUES
1046: ( x_ic_item_cpg_row.item_id
1047: , x_ic_item_cpg_row.ic_matr_days
1048: , x_ic_item_cpg_row.ic_hold_days
1049: , x_ic_item_cpg_row.created_by
1050: , x_ic_item_cpg_row.creation_date
1051: , x_ic_item_cpg_row.last_updated_by
1052: , x_ic_item_cpg_row.last_update_date
1053: , x_ic_item_cpg_row.last_update_login

Line 1050: , x_ic_item_cpg_row.creation_date

1046: ( x_ic_item_cpg_row.item_id
1047: , x_ic_item_cpg_row.ic_matr_days
1048: , x_ic_item_cpg_row.ic_hold_days
1049: , x_ic_item_cpg_row.created_by
1050: , x_ic_item_cpg_row.creation_date
1051: , x_ic_item_cpg_row.last_updated_by
1052: , x_ic_item_cpg_row.last_update_date
1053: , x_ic_item_cpg_row.last_update_login
1054: );

Line 1051: , x_ic_item_cpg_row.last_updated_by

1047: , x_ic_item_cpg_row.ic_matr_days
1048: , x_ic_item_cpg_row.ic_hold_days
1049: , x_ic_item_cpg_row.created_by
1050: , x_ic_item_cpg_row.creation_date
1051: , x_ic_item_cpg_row.last_updated_by
1052: , x_ic_item_cpg_row.last_update_date
1053: , x_ic_item_cpg_row.last_update_login
1054: );
1055:

Line 1052: , x_ic_item_cpg_row.last_update_date

1048: , x_ic_item_cpg_row.ic_hold_days
1049: , x_ic_item_cpg_row.created_by
1050: , x_ic_item_cpg_row.creation_date
1051: , x_ic_item_cpg_row.last_updated_by
1052: , x_ic_item_cpg_row.last_update_date
1053: , x_ic_item_cpg_row.last_update_login
1054: );
1055:
1056: GMIGUTL.DB_ERRNUM := NULL;

Line 1053: , x_ic_item_cpg_row.last_update_login

1049: , x_ic_item_cpg_row.created_by
1050: , x_ic_item_cpg_row.creation_date
1051: , x_ic_item_cpg_row.last_updated_by
1052: , x_ic_item_cpg_row.last_update_date
1053: , x_ic_item_cpg_row.last_update_login
1054: );
1055:
1056: GMIGUTL.DB_ERRNUM := NULL;
1057: RETURN TRUE;

Line 1070: END ic_item_cpg_insert;

1066:
1067: GMIGUTL.DB_ERRNUM := SQLCODE;
1068: GMIGUTL.DB_ERRMSG:= SQLERRM;
1069: RETURN FALSE;
1070: END ic_item_cpg_insert;
1071:
1072: FUNCTION ic_item_cpg_select
1073: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
1074: RETURN BOOLEAN

Line 1072: FUNCTION ic_item_cpg_select

1068: GMIGUTL.DB_ERRMSG:= SQLERRM;
1069: RETURN FALSE;
1070: END ic_item_cpg_insert;
1071:
1072: FUNCTION ic_item_cpg_select
1073: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
1074: RETURN BOOLEAN
1075: IS
1076: BEGIN

Line 1073: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)

1069: RETURN FALSE;
1070: END ic_item_cpg_insert;
1071:
1072: FUNCTION ic_item_cpg_select
1073: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
1074: RETURN BOOLEAN
1075: IS
1076: BEGIN
1077: SELECT * INTO x_ic_item_cpg_row FROM ic_item_cpg

Line 1077: SELECT * INTO x_ic_item_cpg_row FROM ic_item_cpg

1073: (p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE, x_ic_item_cpg_row IN OUT NOCOPY ic_item_cpg%ROWTYPE)
1074: RETURN BOOLEAN
1075: IS
1076: BEGIN
1077: SELECT * INTO x_ic_item_cpg_row FROM ic_item_cpg
1078: WHERE item_id = p_ic_item_cpg_row.item_id;
1079:
1080: GMIGUTL.DB_ERRNUM := NULL;
1081: RETURN TRUE;

Line 1078: WHERE item_id = p_ic_item_cpg_row.item_id;

1074: RETURN BOOLEAN
1075: IS
1076: BEGIN
1077: SELECT * INTO x_ic_item_cpg_row FROM ic_item_cpg
1078: WHERE item_id = p_ic_item_cpg_row.item_id;
1079:
1080: GMIGUTL.DB_ERRNUM := NULL;
1081: RETURN TRUE;
1082:

Line 1103: END ic_item_cpg_select;

1099:
1100: GMIGUTL.DB_ERRNUM := SQLCODE;
1101: GMIGUTL.DB_ERRMSG:= SQLERRM;
1102: RETURN FALSE;
1103: END ic_item_cpg_select;
1104:
1105: FUNCTION ic_lots_cpg_insert
1106: (p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE, x_ic_lots_cpg_row IN OUT NOCOPY ic_lots_cpg%ROWTYPE)
1107: RETURN BOOLEAN