APPS.ASG_HELPER dependencies on FND_API

Line 538: FND_API.G_MISS_CHAR);

534: asg_config_pkg.load_row(p_param_name, p_param_value,
535: p_param_description,
536: sysdate, 1,
537: sysdate, 1,
538: FND_API.G_MISS_CHAR);
539: COMMIT;
540:
541: END set_config_param;
542:

Line 608: -- Returns FND_API.G_TRUE if the user synch is enabled

604: COMMIT;
605:
606: END disable_pub_synch;
607:
608: -- Returns FND_API.G_TRUE if the user synch is enabled
609: FUNCTION is_user_synch_enabled(p_user_name IN VARCHAR2,
610: p_disabled_synch_message OUT NOCOPY VARCHAR2)
611: return VARCHAR2 IS
612: l_synch_enabled VARCHAR2(1) := FND_API.G_TRUE;

Line 612: l_synch_enabled VARCHAR2(1) := FND_API.G_TRUE;

608: -- Returns FND_API.G_TRUE if the user synch is enabled
609: FUNCTION is_user_synch_enabled(p_user_name IN VARCHAR2,
610: p_disabled_synch_message OUT NOCOPY VARCHAR2)
611: return VARCHAR2 IS
612: l_synch_enabled VARCHAR2(1) := FND_API.G_TRUE;
613: l_disabled_user PLS_INTEGER;
614: l_disabled_pubs PLS_INTEGER;
615: l_query_string VARCHAR2(2000);
616: BEGIN

Line 625: l_synch_enabled := FND_API.G_FALSE;

621: WHERE user_name = p_user_name AND
622: enabled = 'N';
623:
624: IF l_disabled_user > 0 THEN
625: l_synch_enabled := FND_API.G_FALSE;
626: p_disabled_synch_message := asg_helper.get_param_value(
627: 'DISABLED_SYNCH_MESSAGE_UC');
628: return l_synch_enabled;
629: END IF;

Line 648: l_synch_enabled := FND_API.G_FALSE;

644: INTO l_disabled_pubs
645: USING p_user_name;
646:
647: IF (l_disabled_pubs >0) THEN
648: l_synch_enabled := FND_API.G_FALSE;
649: p_disabled_synch_message := asg_helper.get_param_value(
650: 'DISABLED_SYNCH_MESSAGE_ACC');
651: return l_synch_enabled;
652: END IF;

Line 673: l_synch_enabled := FND_API.G_FALSE;

669: INTO l_disabled_pubs
670: USING p_user_name;
671:
672: IF (l_disabled_pubs >0) THEN
673: l_synch_enabled := FND_API.G_FALSE;
674: p_disabled_synch_message := asg_helper.get_param_value(
675: 'DISABLED_SYNCH_MESSAGE_PATCH');
676: END IF;
677:

Line 710: IF ((p_pub_item = FND_API.G_MISS_CHAR) OR (p_pub_item IS NULL)) THEN

706: l_uname c_all_users%ROWTYPE;
707: l_recf1 c_new_users%ROWTYPE;
708: BEGIN
709:
710: IF ((p_pub_item = FND_API.G_MISS_CHAR) OR (p_pub_item IS NULL)) THEN
711: return;
712: END IF;
713:
714: l_pub_item := upper(p_pub_item);

Line 790: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR

786: WHERE user_id = p_user_id;
787: l_user_name VARCHAR2(30);
788: PRAGMA AUTONOMOUS_TRANSACTION;
789: BEGIN
790: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR
791: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN
792: return;
793: END IF;
794:

Line 791: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN

787: l_user_name VARCHAR2(30);
788: PRAGMA AUTONOMOUS_TRANSACTION;
789: BEGIN
790: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR
791: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN
792: return;
793: END IF;
794:
795: OPEN C_USER_NAME(p_user_id);

Line 820: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR

816: WHERE user_id = p_user_id;
817: l_user_name VARCHAR2(30);
818: PRAGMA AUTONOMOUS_TRANSACTION;
819: BEGIN
820: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR
821: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN
822: return;
823: END IF;
824:

Line 821: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN

817: l_user_name VARCHAR2(30);
818: PRAGMA AUTONOMOUS_TRANSACTION;
819: BEGIN
820: IF ((p_user_id = FND_API.G_MISS_NUM) OR (p_user_id IS NULL)) OR
821: ((p_pub_name = FND_API.G_MISS_CHAR) OR (p_pub_name IS NULL)) THEN
822: return;
823: END IF;
824:
825: OPEN C_USER_NAME(p_user_id);

Line 847: IF (p_group_name IS NULL) OR (p_group_name = FND_API.G_MISS_CHAR) THEN

843: l_grp_id NUMBER;
844: l_query_string VARCHAR2(2000);
845: BEGIN
846:
847: IF (p_group_name IS NULL) OR (p_group_name = FND_API.G_MISS_CHAR) THEN
848: return;
849: END IF;
850: l_grp_name := upper(p_group_name);
851: